ETL Developer Resume Samples
4.8
(113 votes) for
ETL Developer Resume Samples
The Guide To Resume Tailoring
Guide the recruiter to the conclusion that you are the best candidate for the etl developer job. It’s actually very simple. Tailor your resume by picking relevant responsibilities from the examples below and then add your accomplishments. This way, you can position yourself in the best way to get hired.
Craft your perfect resume by picking job responsibilities written by professional recruiters
Pick from the thousands of curated job responsibilities used by the leading companies
Tailor your resume & cover letter with wording that best fits for each job you apply
Resume Builder
Create a Resume in Minutes with Professional Resume Templates
CHOOSE THE BEST TEMPLATE
- Choose from 15 Leading Templates. No need to think about design details.
USE PRE-WRITTEN BULLET POINTS
- Select from thousands of pre-written bullet points.
SAVE YOUR DOCUMENTS IN PDF FILES
- Instantly download in PDF format or share a custom link.
KD
K Donnelly
Kenton
Donnelly
6386 Hermann Shoals
San Francisco
CA
+1 (555) 521 6165
6386 Hermann Shoals
San Francisco
CA
Phone
p
+1 (555) 521 6165
Experience
Experience
Philadelphia, PA
ETL Developer
Philadelphia, PA
Nolan-Schaefer
Philadelphia, PA
ETL Developer
- Works within IT team to follow the full lifecycle development process working with development and technical operations
- Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions
- Manage, mentor and develop onshore development resources and provide project related directions to offshore team
- Assist Service Manager and Service Director in providing management status reports on daily, weekly and monthly basis
- Assist business and technology stakeholders in establishing data management framework with necessary data quality controls and governance
- Communicate effectively with the other external IT development teams and the local development manager
- Work with other team members in establishing and sharing design and development techniques of the ETL process
New York, NY
Database / ETL Developer
New York, NY
Kohler-Miller
New York, NY
Database / ETL Developer
- Provide process improvement analysis using process modeling and simulation techniques to understand the impact of process changes
- Provide operational analytics to support better management of MIS
- Attend technology design meetings and recommend security and data improvements – and will be empowered to work on those prioritized changes
- Develop scripts to automate the execution of ETL using shell scripts under Unix environment
- Providing routine process/operational control reports and/or Controls Dashboard support
- Help develop test cases and plans to complete the unit testing and support System testing
- Assist in software and hardware setup
present
Detroit, MI
Lead Etl Developer
Detroit, MI
Mills, Bosco and O'Connell
present
Detroit, MI
Lead Etl Developer
present
- Lead overall data management solutions and design, change the status quo and create world class information management solutions
- Provides updates to the management and the business to keep them informed of any system issues
- Provides input to development project plans
- Manage the successful delivery of development projects across the full application lifecycle
- Mentor junior developers on the best practices for developing ETL jobs utilizing Informatica
- Ensure all metrics data is collected for all critical processes during the Design and the Development Phases of the SDLC lifecycle
- Provide governance to the review processes and effectively communicate out project status
Education
Education
Bachelor’s Degree in Computer Science
Bachelor’s Degree in Computer Science
Ohio University
Bachelor’s Degree in Computer Science
Skills
Skills
- Strong Oracle PL/SQL knowledge and ability to code complex queries against a marketing database
- Excellent writing skills, oral communication skills, strong process skills, and leadership ability
- Detail-oriented drive to investigate and dissect information with a strong focus on quality
- Commitment to quality highlighted by strong auditing capability
- Solid knowledge of the UNIX/Linux environment
- Demonstrated ability to translate functional/high level design in detailed technical design
- Strong technical aptitude and ability to logically analyze and creatively solve complex issues independently
- Strong interpersonal skills and ability to work effectively with all levels throughout the enterprise
- Basic knowledge of Business Objects reporting tools like Web Intelligence, Lumira etc
- Extensive experience in data analysis and/or reporting along with strong knowledge of database and related technologies (SQL, OLAP, etc.)
15 ETL Developer resume templates
Read our complete resume writing guides
1
ETL Developer Lead-hrt Resume Examples & Samples
- Work closely with the business leads to understand and finalize the requirements
- Participate in the continuous improvement of the application, develop best practices
- 10 to 15 years of industry experience in information technology. Data-warehousing experience is a strong plus
- 5 to 7 years of Oracle experience with strong fundamentals in performance and tuning, efficient SQL writing, stored procedures/PLSQL coding etc
- 5 to 7 years of experience with Informatica or any other ETL tool is a must
- Working knowledge of Unix/Linux
- Ability to interact with all levels of management
2
ETL Developer Resume Examples & Samples
- Analyze requirements and develop ETL/BI reports with minimal supervision
- Design and develop BI programs with consideration to data quality, data integrity and performance
- Design and develop database objects with consideration to best practices and reporting needs
- Conduct unit testing and participate in integration and system testing as required
- Perform general system maintenance and support as necessary
- Minimum 5 years experience developing ETL solutions for data warehouse environments
- Minimum 3 years experience using Informatica PowerCenter 8.6 or higher
- Experience using Informatica to interface with Salesforce is highly desirable
- Experience in optimizing/tuning ETL objects, indexing and partitioning for better performance and efficiency
- Knowledge of industry best practices for ETL and the common approaches to data warehouse architectures
- Minimum 1 year experience in design and development of Business Intelligence solutions, using Business Objects or Cognos
- Strong experience of data warehouse solutions using implementations of star and snowflake schemas
- Strong database experience working with various RDBMS platforms; knowledge of Oracle 10g/11 and Sybase 12x
- Strong experience in writing ANSI SQL code, as well as the ability to design and implement functional, stress and regression tests to assure correct operation of application
- Knowledge of Unix and shell scripting skills are a plus
- Good understanding of the software project lifecycle
- College degree, or specialized training
- Asset Management and/or Financial Services experience desirable
- Understanding of software development methods, including Agile
3
Junior ETL Developer Resume Examples & Samples
- Application Development of related projects/enhancements/bug fixes for the accounting platform, including interfacing with Operations and other business users
- Troubleshooting business issues, solving problems to provide solutions to diverse teams and the product aligned support areas
- Work with other Back Office Technology teams to make appropriate changes that will enhance the stability of the overall environment
- Ownership and participation in the Incident and problem management processes, being accountable for resolution, root cause analysis and technology and business reporting and communication
- Relationship management internally with the back office, trade support, and at times front office teams
- Navigate the wider technology organization; build relationships to help manage the team’s agenda with our critical technology partners
- Interface with external vendors and their technical support and development organizations ensuring focus to resolution of issues and strategic enhancements
- Proactively identify improvements and address them through independent thinking within a consensus driven team
- 2+ years experience in financial services with a focus in Securities Processing
- Understanding of the agile development methodology
4
Senior Data & ETL Developer Resume Examples & Samples
- Work in a globally distributed team that will deliver Business driven projects and IT solutions for Data & ETL requirements for Insights and non-Insights spaces
- Understand the requirements, design and implement data sourcing solutions by doing data modeling and implementing ETL using technologies like TeraData, Informatica and TWS
- Provide support to the different Insights and non-Insights dev teams for their data needs
- Productionize the ETL changes by going through the review and approval processes by interfacing with different teams like engineering, operations and DBAs
- Stay up to date on the evolving data architecture of the Insights applications
- Provide support to the Business in adhoc query space
- Interface with the business team and business analysts, support QA & UAT Testing, deployment, and Level 3 support for Data & ETL
- A minimum of 10 years of experience in IT, 5 years in Retail Brokerage IT
- Excellent knowledge of and experience with data warehousing/data marts concepts and practices viz. TeraData and Informatica is a must
- Demonstrated expertise with the some of the following tools/languages/disciplines: data modeling, data profiling, relational database SQL (e.g. SQL Server, Sybase)
- Experience in BigData technologies like Hadoop, HBase, Hive, HDFS
- Knowledge of retail broker dealer business; back-office operations and trade processing; familiarity with a wide range of financial instruments; such as stocks, options, mutual funds, fixed income
- Prior experience in data quality and data stewardship functions is a plus
- Bachelors/Masters Degree in Engineering, preferably Computer Science/Engineering, from a top tier University
- Background in Financial Services required
- Excellent communication skills in English language are essential, both written and oral
- Good interpersonal skills with the ability to facilitate or contribute thought leadership are required
5
ETL Developer Resume Examples & Samples
- Partner with the infrastructure and architecture team to enforce best practices for all aspects of systems development including requirements, design, build and testing/validation
- Manage the relationship with internal and external services vendors to ensure superior service delivery for all application core technologies
- 5 years of professional experience as an ETL developer in an Enterprise Data Warehousing environment; hands on experience with Informatica and Teradata
- Experience with issue resolution processes for application production problems
- College degree or specialized training / equivalent work experience
6
Ab-initio ETL Developer Resume Examples & Samples
- 3-5 years in Ab-Initio development roles with experience on large & complex projects
- Data warehousing experience is required
- Appreciation of IBM Business Data Warehouse models is a plus but not a prerequisite for this position
- The candidate should be proficient with Oracle PL/SQL, Autosys and shell scripting
- Non-technical knowledge, experience, and skills (leadership, management, oral and written communication)
7
ETL Developer Resume Examples & Samples
- Development and implementation of technology solutions
- Adding clarity to business requirements; translate functional requirements into technical requirements; check the technical feasibility of all business and functional requirements
- Work with external and internal suppliers to flesh out and develop technical solution
- Take responsibility for ensuring that build and code adhere to architectural and quality standards and policies
- Experience in ETL development (experience in Informatica or Ab Initio would be an advantage)
- Basic knowledge of Linux
- Basic knowledge of databases and SQL (Teradata would be an advantage)
- Prior knowledge of AML (Anti-Money Laundering) is an added advantage
- Strong client facing skills with a proven track record of building relationships with business and technology stakeholders at all levels
8
ETL Developer Resume Examples & Samples
- Strong data warehousing and OLTP system knowledge from database/ETL development perspective
- Strong Oracle database knowledge including database design, development (package, procedure, functions, indexes)
- Datastage 8.1 knowledge required
- Ability to develop technical design using Visio and interpret and relate the business requirements to technical components
9
ETL Developer Resume Examples & Samples
- Experience with 1 or more mainstream ETL tools (Talend 5.x, DataStage, Informatica) (3-5 years)
- SQL Server 2005 or greater (3-5 years)
- Experience with multiple relational database environments (SQL Server, Oracle, DB2, Informaix, etc)
- Experience working with various file types (ASCII, XML, EBCDIC)
- Experience with data mapping analysis and design
- Experience building roadmaps
- Source code tools such as TFS and Subversion
- Experience with operational data stores and data governance routines (PCI, NPI, Data Quality controls, etc)
- Ability to work effectively with minimal supervision
- Ability to multi task and adapt to change
- Ability to communicate with Line of Business clients
- Ability to analyze requirements documents for impacts
- Experience with Waterfall and/or Agile project management processes
- Java 7, JQuery, WebSphere 8.5.x, Spring Batch, Autosys, Drools, J2EE
- Experience with Financial data or Collections and Recovery business a plus
- Experience with Big Data concepts and tools
- Experience with Hadoop eco-system a plus (HIVE, Impala, HDFS, Cloudera)
- Six sigma certification (green belt with lean or other)
- Quality Center, Maximo, NEWs or other change management and testing tools
- Direct Connect NDM, SFTP, SSH
10
ETL Developer Resume Examples & Samples
- Read, analyze and provide feedback and changes on business requirement documents
- Design, build, testing and maintenance of data integration / ETL processes
- Assist with design and implementation of staging areas and data warehouse
- Design and implementation of data quality and data cleansing requirements / methodologies
- Manage scheduling, support, tools and maintenance of integration processes
- Interaction and collaboration with other team members and business users
- Work with software vendor on trouble tickets / debugging efforts
- Provide / ensure data needs / requirements for data warehouse projects
- Requirements gathering, technical documentation
- Mentor and train other project staff
- 3 years of experience working with an ETL toolset in an Enterprise Data Warehouse environment (Informatica preferred)
- Database scripting background helpful
- Strong database knowledge (TeraData, DB2, Microsoft SQL Server)
- Experience with Data Warehouse lifecycles and methodologies
- Prior experience / role on an EDM/EIM team
- Experience with OLAP Cubes / Cognos Business Intelligence tools a plus
- Experience working with key business data such as sales, inventory, financials
- Skilled at requirements definition, data and process modeling, and the use of modeling tools
11
ETL Developer Resume Examples & Samples
- Managing the tasks and timelines to ensure project milestones are met
- Ensure that technical components adhere to existing standards
- Keeping abreast of leading edge of development and ETL practices
- Understanding and clarifying business requirements, mappings and transformation objects
- Building data quality checks into developed applications and processes
- An appropriate level of documented unit testing is performed prior to implementation
- Transformations and processes, and an impact analysis is carried out prior to any enhancements
- Problems / errors are thoroughly investigated and resolved in a timely manner by involving the appropriate people in T&O
- Processes and system enhancements are implemented to prevent reoccurrences of issues
- Bachelor’s degree in Computer Science Degree or related IT certification
- Demonstrates good communication and interpersonal skills
- Exhibits good problem solving and analytical skills
- Possesses good customer service skills
- Is able to quickly establish rapport with business partners
- Demonstrates high attention to problem description, detail, and impact
- 3-5 years of development experience
- 3-5 years ETL development experience
- Strong hands on experience with SQL scripting is a must have
- Experience with developing in a UNIX environment, strong UNIX scripting is a must have
- Experience with relational databases like DB2 and Oracle
- Experience with the ETL tools preferably IBM Data stage, Quality Stage, Informatica or similar skills is a must have
12
ETL Developer Resume Examples & Samples
- Ability to work in a team environment including effective communication within development groups, product, and business
- Completion of customer / contract specific development
- Rapid customer issue resolution
- Collaborates with manager to develop efficient, goal oriented code
- Collaborates with manager to develop with a focus on scalability / quality
- Work with Account Management and customers to diagnose issues and develop solutions
- Manages time effectively
- Bachelors degree in Computer Science, Electrical Engineering, or equivalent
- Experience with data movement, transforms, and loads
- 2+ years of programming languages
- PHP, MySQL, HTML, JQuery / Javascript, and CSS experience
- Experience with MySQL advanced functions, procedures and triggers a plus
- Knowledge of relational database design concepts
13
ETL Developer Resume Examples & Samples
- Has rich experience in working on multiple complex ETL and data integration projects
- 4+ years hands-on experience in Ab-Initio (preferred) and other ETL tools
- 4+ years hands-on experience in Java
- Very good Unix and Shell scripts skills
- Experience with Autosys will be a plus
- Very good SQL and relational database experience such as DB2, Oracle
- Any data modeling and dimensional design skills will be a plus
- Good expertise in technical analysis/debugging problems/troubleshooting issues
- Ability to work successfully under pressure in a dynamic, multitasking environment
- Bachelor’s degree in Computers, Information Technology or Engineering
14
ETL Developer Lead-data Management & Analytics Resume Examples & Samples
- Adhere to standard Data Warehousing techniques in integrating the various source systems into the target ICDW infrastructure
- Oversee formal testing processes and procedures
- Work with Application Leads and Business Managers to define and monitor Service Level Agreement's and support commitments for existing products
- Establish/communicate a quality solution that will enable the group to implement changes into the target ICDW in a timely and efficient manner
- 7+ years of Application Development experience
- 5+ years of professional experience as an ETL developer in an Enterprise Data Warehousing environment; hands on experience with Informatica and Teradata is preferred
- 3+ years of experience writing Unix Shell Scripts
- Proven ability overseeing installations and Release Management including the final production acceptance review and signoff
15
Junior ETL Developer Resume Examples & Samples
- Be hands-on, implementing with and expanding your knowledge of proprietary internal toolsets as well as established technologies such as: XML, XSLT
- Support existing integrations directly with our clients, ensuring our core offering is delivered without exception: quality, accuracy, and extreme cost efficiency of data transformation and delivery
- Experience with XPath concepts and logic
- Exposure to Altova toolsets for XML
16
Am-etl Developer Resume Examples & Samples
- Communicate with as well as direct Offshore team members
- Participate in all Development Lifecycle processes
- Incorporate security requirements into design
- ETL Informatica developer with data warehouse/datamart experience in the financial industry
- Work with Business Intelligence tools a plus – especially Business Objects
17
Fees Database & ETL Developer Resume Examples & Samples
- Data analysis and database design
- In-depth knowledge, hands-on experience with ETL
- In-depth knowledge, hands-on experience with RDBMS systems; specifically SQL server, Sybase, Teradata, and/or Oracle
- Strong SQL skills and database programming skills; creating views, stored procedures and triggers, implementing referential integrity, designing and coding to optimize performance
- Strong Communication skills, both written and oral
- Experience in the Financial Industry, Retail Mortgages
- Experience in at least on of the following: Informatica, Business Objects, Teradata, SSIS, SQL Server or Oracle development
- Experience interacting with Business partners on requirements, built prototypes to conceptual model including screen flows. Has the ability to demonstrate the working concept and solicit feedback
- Ability to device solution and document them as part of design
- Continuously learns and adapts market technology trends and applies them as appropriate
- Strong problem solving and design skills
18
Etl Developer Risk Systems Resume Examples & Samples
- Serves as an lead application technical expert on specific aligned applications
- Works with projects teams and systems analysts to translate technical requirements into optimally coded solutions which adhere to GE standards for architecture, security, stability and incident support
- Demonstrates command of multiple programming languages and basic system analysis techniques
- Participate in off-hours application support as needed
- Bachelor's Degree (or minimum 4 years equivalent work experience) with minimum 2 years of IT experience
- Minimum 2 years of experience in Informatica and other ETL tools including advanced features
- Minimum 2 years of experience in Teradata and Oracle experience Eligibility Requirements
- Must be able to satisfy the requirements of Section 19 of the Federal Deposit Insurance Act
- GE will only employ those who are legally authorized to work in the United States for this opening. Any offer of employment is conditioned upon the successful completion of a background investigation and drug screen
- Minimum 2 years of software development experience involved in all phases of the software development lifecycle
- Broad knowledge of IT systems, infrastructure, processes and controls
- Knowledge of IT controllership methodologies and standards; demonstrated experience though project execution compliant with systems development life cycle methodology
- Experience in normalized and dimensional logical modeling
- Possesses excellent SQL skills
- Ability to concurrently manage multiple projects and incidents
- Data Validation Option (DVO) experience #DTR
19
ETL Developer Resume Examples & Samples
- Technically proficient in Abinitio features and functionality (experience in cooperating version 2.15 and 3.x)
- Strong practical knowledge of EME
- Multitasking capability - working in multiple projects
- Experience in Version control system (PVCS, VSS, etc.) is preferred
- Experience in ETL and Abinitio migration and upgrade projects
- Experience in driving a full lifecycle development of ETL projects
- Banking/Financial Services domain knowledge is preferable
- OS - Windows, Unix
- Proficient in working on backend technologies like Oracle/PL/SQL and stored procedures/triggers, etc
- Proficient in Unix Shell scripting
- Good technical analysis and troubelshooting skills
- Experience in designing and architecting medium to complex systems, well-versed with design standards and framework
20
Etl Developer Ayala Avenue, Makati Resume Examples & Samples
- Flexible in dealing with conflicting and changing priorities, and multi-task
- Highly self motivated and capable of working with minimal input and supervision
- A problem solver with strong analytical skills
- A strong communicator, both written and verbal
- Strong on detail
- A fast learner willing to take on new challenges
21
DB / ETL Developer Resume Examples & Samples
- Ensure to complete and deliver all assigned tasks on time with quality
- Should be able to multitask working simultaneously on more than 1 task at any given time
- The ideal candidate will possess a good compliment of IT skills and technical experience in Oracle and ETL
- Relevant work experience needed is between 3-4 years
- Candidate should have hands-on experience in Oracle and ETL technologies
- Exposure to IBM JRules and ETL tool
- Talend is a big plus
- Must include excellent communication and problem solving skills
- Should possess strong analytical and troubleshooting skills
- Bachelor's degree or equivalent work experience in Computer Science, Information Systems, or other related field
22
ETL Developer Resume Examples & Samples
- Strong experience in Ab-Initio ETL development Tool and understanding of data integration best practices in data warehouse environment
- Demonstrate a strong understanding of key business drivers and ensure technical solutions deliver business value in line with the company objectives
- Strong development analysis skills and be qualified to technically lead a team of developers
- Can perform independently and guide, assist or mentor others in analyzing, designing, coding, testing, debugging, documenting, and installing a large/complex or several smaller solutions
- Provide prioritization, planning, estimating, work assignments, quality assurance and mentoring at any stage of a project
- Responsible for communicating to management on status, problems, issues and underlying process problems
- Identify and develop the Technical detail design document
- Document and present solution alternatives to clients, which support business processes and business objectives
- Demonstrate anticipation and initiative in the planning for and management of problems
- Resolve or escalate problems, and manage risk for both development and production support
- Coordinate vendors and contractors for specific projects or systems
- Maintain deep knowledge and awareness of technical & industry best practices and trends, especially in technology & methodologies
- Ensure that good business relationships are maintained with multiple clients and other IT departments to ensure successful implementation and support of project efforts
- Participate in the evaluation of new software and hardware
- Provide input to manager with respect to training needs of team members
23
ETL Developer Resume Examples & Samples
- 4+ years experience with Informatica
- Can perform independently and guide, assist or mentor others in analyzing, designing, coding, testing, debugging, documenting, and installing a large/complex or several s maller solutions
- 5 or more years of hands-on experience developing software with Informatica and some Ab Initio (GDE v1.15) ETL tool and at least 2 years of technical lead experience
- 5 or more years experience in analyzing, designing, coding, testing, implementation, documentation and maintaining complex software programs
- 2 or more years experience developing in a UNIX/Teradata environment required
- SQL programming and performance tuning experience is required
- Strong experience in Data Quality, Source Systems Analysis, Business Rules Validation, Source
- Target Mapping Design and High Volume Data Loads
- Experience with Data Warehouse development
- Understanding of data modeling desired
- Experience with Oracle desired
- Considerable business knowledge, preferably the retail industry
- Ability to exercise judgment within broadly defined practices and policies in selecting methods, techniques and evaluation criterion for obtaining results
- Demonstrated leadership in instructing, guiding and overseeing the work of team members
- Would require working with business users understanding requirement and training them on data retrieval from Teradata
- Enough practical experience to train others in decision making, risk assessment, job knowledge, analysis, and project management
- Ability to work independently and multi-task to meet critical deadlines in a rapidly changing environment
- Control-M experience is a plus along with PowerCenter ETL and Hadoop experience
- LI - DV
24
ETL Developer Resume Examples & Samples
- Deliver ETL and related components as specified in the design, functional and non-functional requirements within established time and quality standards
- Develop, test and document existing and new ETL related components; make recommendations for related functions that result in a more cost effective product delivery
- Troubleshoot and fix coding defects and support all testing cycles, including but not limited to: Development Integration Testing, System Testing, User Acceptance Testing, End-to-End Testing, and Performance Testing
- Provide application integration support
- Perform code version control activities
- Create and update all necessary documentation for the Project
- Deliver effective and efficient solutions by meeting key project milestones and ensure that the project deliverables are on time and adhere to the corporate quality and security standards
- Experience with IBM DataStage and QualityStage
- DataStage XML components
- Current hands-on Unix/Linux shell scripting experience
- General database knowledge and expertise in SQL
- Proven problem solving and debugging skills
- In depth understanding on XML concepts and XML processing
25
ETL Developer Resume Examples & Samples
- ETL Developer is responsible for Software development by using Data stage advanced technologies
- ETL Developer is responsible for Shell Scripting and provide support on various software functions like SQL & DB
- Development experience in DataStage 7 or 8
- DB2/SQL or Oracle and good knowledge in DB2/SQL
- Shell scripting in AIX and/or UNIX
- At least 2 years experience in ETL Development
26
ETL Developer Resume Examples & Samples
- 1 – 3 years of technical experience and an Associate of Arts/Science or equivalent degree (two year college program) in computer science or related area of study; without a degree, one additional year of relevant technical experience (2-4 years in total)
- Has sufficient technical knowledge to assist with the completion of specific deliverables
- Able to communicate concepts with team and to peers
- Able to produce basic documentation to required standards
- Demonstrates understanding of assigned discipline or technical area. Demonstrate fundamental technical knowledge
27
ETL Developer, Senior Resume Examples & Samples
- 3 plus years application systems development/maintenance or ETL support experience
- 1+ years’ SAS programming work experience
- 1+ years’ SQL Server Integration Services (SSIS)
- 3+ years experience with Relational databases like Oracle and SQL Server
- Experience with SQL Server Reporting Services (SSRS) a plus
- Experience in Developing Client Server Applications using Microsoft .NET Framework, C# a plus
- Ability to learn new technologies, solves complex technical problems and multitask initiatives
28
ETL Developer Resume Examples & Samples
- Understanding the data and the needs of upstream and Downstream systems
- Understand the data architecture and ability to understand and work on data models
- Design and implement high quality ETL deliverables for the various reporting and Integration requirements
- Troubleshoot and come up with innovative and performance efficient solution to address the problem
- Strong knowledge and experience with Terradata Database and writing SQLs
- Prior work experience on any ETL tools is a must. Experience with "Abinitio" is an added advantage
- Should be able to understand Data Models and must be able to independently work on Design and development of ETL jobs
- Must have strong knowledge of performance tuning of SQLs and ETL packages
- Prior experience of working on agile development teams with a strong focus on quality
29
Etl Developer Ab Initio Resume Examples & Samples
- Responsible for all ETL processes of the global corporate actions platform
- Lead & work with the development team and other partner system teams
- Work proactively to address project requirements, and resolve issues/challenges within acceptable timeline
- Manage the releases across multiple instances in production & test environments
- Be an active member of level 3 support team and oversee the activities of L1 & L2 support teams
- Manage competing priorities of business, with minimum or no loss of efficiency on project deliverables
- Bachelor’s Degree in Computing or Engineering
- Minimum 5 years of IT experience required
- Hands-on experience of ETL Tool (Preferably Ab Initio)
- Strong knowledge of Scripting Technologies - UNIX shell script & Batch Script
- Understanding of database (MSSQL preferably) with ability to write queries and stored procedures
- Experience in Finance Industry
- Knowledge of SWIFT Standards
- A self-starter who can deliver well as part of a global team
30
ETL Developer Resume Examples & Samples
- Maintain communication with internal stakeholder on progress and deadlines
- 2+ years of database development using either SQL Server or MySQL (but with significant experience using both)
- 2+ years of ETL development using SSIS and related tools
- Good data modeling and SQL coding skills
- Experience performing basic DBA activities such as scheduled maintenance, upgrades, backups, performance tuning and troubleshooting
- Excellent troubleshooting skills with demonstrable experience identifying bottlenecks in existing database/ETL processes
- Good problem solving and negotiating skills
31
Experienced ETL Developer Resume Examples & Samples
- Support production deployment
- Identify and address technical issues in due time
- Ability to translate architecture documents in functional specification documents
- Development experience in DataStage 7.5 / DataStage 8.X
- Oracle DB 10g, 11g
32
Abinitio Etl Developer Resume Examples & Samples
- Code, test, modify, debug, document, and implement Abinitio Graphs utilizing the GDEenvironment and EME
- Document detailed application specifications; Create and translate technical requirements into programmed application modules
- Participate in design reviews / code reviews and ensure that all solutions are aligned to pre-defined architectural specifications; identify/troubleshoot application code-related issues; and review and provide feedback to the final user documentation
- Assume ownership and accountability for the assigned deliverables thru all phases of the development lifecycle
33
ETL Developer Resume Examples & Samples
- SQL and RDBMS' like Oracle or Sybase
- ETL technologies like Informatica
- Building and deploying an Investment Book of Record
34
ETL Developer Resume Examples & Samples
- Creates ETL specifications that align with interface and data requirements
- Develops ETL code to transport large volumes of data into a central data warehouse
- Actively participates in discussions with Business Analysts, Developers and Testers to address requirements implementations
- Provides ETL expertise to the business processes supported by ETL applications
- Assists in the assessment of new technologies to enhance the development process
- 3+ years of software development experience involved in all phases of the software development lifecycle
- Oracle RDBMS experience (including stored procedure development in PL/SQL)
- Interface requirements definition experience
35
ETL Developer Resume Examples & Samples
- Develop client integration solutions and support the deliverables to include eligible member, claims and biometric data
- Perform ETL Development for inbound File Feeds, file loads and various controls
- Fine-tune ETL processes for performance optimization
- Demonstrate self-reliance in researching technical solutions and product functionality
- Continuously improve upon existing approaches by seeking opportunity to creatively transform current business practices into fresh alternative solutions
- Identify solutions to critical integration issues and develop corrective solutions
- Communicate with team members to assess progress of deliverables
- Create and maintain data integration documentation
- 6+ years of ETL Development experience with strong ETL and SQL programming skills (required); MySQL experience (desired)
- 4 years Bachelor's degree in Engineering or equivalent
- Experience with ETL (required), Pentaho, Pervasive or similar tools (preferred)
- Proficient technical skills to include (SQL DDL and DML, ETL methodologies, TOAD, Perforce, MySQL, Database Schemas)
36
ETL Developer Resume Examples & Samples
- Access disparate data sources (databases, hardware devices, VSAM and flat files) and apply internal and external business rules, policies and data quality measures
- Insure the data is safely and securely transferred to target destinations
- Maintain an in-depth knowledge of current and emerging technologies and standards and provide technical direction to management and users
- Provide technical direction to other team members including contractors and employees
- Performs other duties, as assigned
- 5+ years of experience with the IBM InfoSphere Information Server ETL tool in a data warehouse environment is a must. Experience with both Server and Enterprise editions preferred
- Knowledge of database loading methods
- Knowledge of data warehousing methodologies
- Knowledge of mainframe file structures, namely copybooks is a plus
- Knowledge of all phases of the system development life cycle
- Demonstrated ability to take ownership & responsibility for development and maintenance projects
37
Ab Initio Etl Developer Resume Examples & Samples
- Initial Investigation & solution identification
- Analyzes, Designs, develops, codes, tests, debugs and documents
- Support QA phase by tracking and assigning defects to development team; Work with QA leads to schedule fixes and builds and enable QA to be successful
- Implementation and Warranty support
- Identify ways to increase efficiency of production support - Find solutions that allow operations to better do their job
- Works with other team members, including DBA's, ETL developers, Technical Architects, QA , Business Analysts & Project Managers
- Excellent knowledge of the Full life cycle of a project
- Mentor younger member of the team
- Bachelor's degree in Engineering
- Master's degree in Finance OR Information Technology is a plus
- Minimum 5 years of hands on work experience in Ab Initio (Application development)
- At least 6 yeards software development experience required in Operational Data Store / Data Warehouse environment
- Knowledge of release management, version control practices and procedures
- Experience with scheduling jobs using a scheduling tool like Control-M
- Demonstrated ability to translate functional/high level design in detailed technical design
38
Ab Initio Etl Developer Resume Examples & Samples
- Analyzes, Designs, develops, codes, tests, debugs and documents to satisfy business requirements
- Experience in managing deliveries on application releases
- Conduct / Participate in design reviews and provide alternatives
- Conduct / Participate in code reviews and make sure quality solutions are implemented to design specification and best practices/standards have been followed
- Responsible for on-time project / L3 Releases delivery with high-quality code
- Support QA phase by tracking and assigning defects to development team; work with QA leads to schedule fixes and builds and enable QA to be successful
- Identify ways to increase efficiency of production support - Find solutions that allow operations to better do their job without involving development resource time
- Ensure that solutions are not one-offs, but can be leverage across the organization
- Minimum 5-7 years of hands on work experience in Ab Initio (Application development)
- At least 9-10 years of software development experience required in Operational Data Store / Data Warehouse environment
- Ability to provide optimal solution/design to problem definition
39
Analyst Etl Developer Resume Examples & Samples
- Participate in the full lifecycle of ETL software development - analysis, design, build, documentation and testing
- Collaborate with project managers, analysts, technical leads, business partners and developers throughout the SDLC
- Develop technical designs and build Informatica workflows, mappings, shell scripts, stored procedures, clearly documenting the process
- Create and execute unit tests on all solutions, work with Data analysts and QA engineers to ensure product and integrations tests are complete
- Work with the release manager, data analysts, and prod ops team to ensure solutions are well tested, production ready and well documented
- Work with the both project and support teams to understand existing systems and to help troubleshoot, optimize, and tune ETL processes as needed
- Build strong relationships with the peers, analysts, technical and business leads through delivery, communication and development of domain knowledge
- 3-6 years hands on experience developing Informatica mappings and workflows
- 3-6 years’ experience with UNIX shell scripting
- 3-6 years in data modeling and development with demonstrated strength in SQL, and stored procedures. Sybase preferred
- 3+ years’ experience with Data warehousing techniques (Star Schema, snow flaking, denormalization, Normalization, Aggregations)
- 3+ years working in a fast-paced environment, including multiple projects at any one time
- Experience working with XML document structures and hierarchical data
- Experience with Messaging is preferred, in particular IBM MQ series
- Minimum BA/BS degree
- Demonstrated interest in financial services required, experience preferred
- Excellent analytical and problem-solving skills coupled with attention to detail and thoroughness
- Strong teamwork, communication skills and time management abilities required
- Experience working in a global team environment
40
ETL Developer AVP Resume Examples & Samples
- 7 years minimum experience with strong ETL (Informatica/ Talend/ DataStage ), DW (OLTP and OLAP) methodology concepts
- Must be able to write complex Oracle database stored procedures/packages
- Strong experience with SQL queries
- Experience creating scripts in Unix/Java
- Strong database development capabilities
- Experience with high performance & high volume data ware house systems in a high pressure environment
- Must have demonstrated design and delivery experience in the full life cycle of data
- Should have experience of sourcing data from multiple systems using ETL to implement data transformation rules and load into the data warehouse
- Ability to carry out adaptive changes necessitated by business and technology
- Display sound analytics, problem solving, presentation and inter-personal skills to handle critical situations
- Bachelor’s degree in Computer Science & Engineering or similar discipline
- Banking experience would be an advantage
- Abinito experience is a plus
- Big data integration and cloud experience would be preferable
41
ETL Developer Resume Examples & Samples
- Bachelor’s Degree in Computer Science or related field of study required
- 3+ years of ETL experience utilizing Pentaho Data Integration required
- Advanced working knowledge of scripting languages necessary
- Previous professional or personal experience in Financial industry a plus
42
ETL Developer Resume Examples & Samples
- Develop code for technical frameworks and application
- Manage the developed code through the various test cycles and eventual production implementation
- Work with global teams on development tasks
- 5+ year’s industry experience
- 5+ year’s hands-on experience writing code
- Experience with relational databases such as DB2 or Oracle
- Very good Unix and Shell scripts skills. Experience with Autosys will be a plus
- Experience with Volante will be a plus
- Financial industry experience is plus, preferably with Cards or Payments
43
Database / ETL Developer Resume Examples & Samples
- Under direct supervision, responsible for program analysis, design and specification for own programs
- Application coding using SQL Service (TSQL, SSIS, DDL) and SSRS Reporting
- Data loading using ETL tools
- Under general supervision responsible for coding, testing, debugging and implementation into production
- Participate and assist project leader in project planning
- Contribute task level estimates for work and time to project plan
- Complete required documentation
- Follow company standards, policies, procedures, and guidelines
- Escalate project issues in a timely manner
- Follow managers’ direction regarding project priorities, milestones and initiatives
- Assist in software and hardware setup
- Assist in ensuring that systems are not vulnerable to known security exploits
- Satisfy programming requirements for the unit of work assigned, with moderate supervision
- Proficient with MS SQL Server, SSRS, SSIS, and other ETL tools
- Source code control using TFS
- Understand database design practices, including database normalization concepts
- Exhibit a disciplined approach in unit and component testing to ensure zero defects
- Determine the appropriate unit test cases, including functional and regression cases
- Perform analysis and design on the component level
- Complete appropriate documentation (test plans)
- Adhere to design and programming standards and principles as defined by senior team members
- Have a basic grasp of the core business functions in their area of work
- Have a good grasp of the main system flows and functions in their area of work
- May participate in the gathering, writing and reviewing of business requirements and translating into functional specifications (FRD process)
- Possess root cause analysis skills; able to quickly analyze and interpret code
- Escalate support issues appropriately
- Take ownership for issues; follow up on resolution even when resolved by other
- Participate in post-project review when appropriate
- Communicate with team leader regarding specifications and requirements relevant to unit of work
- Possess strong written and oral English communication skills
44
ETL Developer Resume Examples & Samples
- Ensures ETL process is developed in modular fashion in shared folders and reusable objects to enforce consistency timely development. Reviews ETL production design for performance optimization
- Resolves issues through troubleshooting and quick diagnoses
- Bachelor’s Degree in Business or equivalent combination of education and experience required
45
Lead Etl Developer Resume Examples & Samples
- Provide technical leadership in the Design and the Development Phases of the SDLC lifecycle for the implementation of Informatica ETL components within the data warehouse architecture
- Accountable for the creation of the technical specification and the unit testing cases based on the specification. Details of the technical specification include the acquisition of source data, validation of data integrity, standardization of data, loading to the data warehouse, data reconciliation and archiving of data
- Mentor junior developers on the best practices for developing ETL jobs utilizing Informatica
- Be a sounding board for Analysts/Developers/QA and oversee the overall coding effort as it relates to the ETL components of the architecture
- Provide governance to the review processes and effectively communicate out project status
- Act as the primary interface to the architecture team and influence architectural decisions based on their platforms needs and the usage of tools to support the data warehouse architecture
- Responsible for setting ETL coding standards, establishing/maintaining best practices, adopting the CMMi framework and driving these principles throughout Delivery
- Ensure consistent on-time, within estimate delivery of quality systems initiatives in accordance with agreed upon plans
- Ensure all metrics data is collected for all critical processes during the Design and the Development Phases of the SDLC lifecycle
- 8+ years of IT based software development
- 8+ years developing data warehouse architecture components utilizing Informatica
- Knowledge of systems, application architecture, data warehouse architecture and data modeling
- Solid knowledge and experience of database and programming languages (specifically Oracle and Informatica)
- Knowledge of software development life-cycle for data warehouse and business intelligence projects
- Ability to effectively communicate and influence others
- An active participant in the growth of the organization; Being a Change Agent
- Critical thinker
- Excellent customer focus
- Multi-site team environment experience preferred
- Skill at resolving conflict and negotiating effectively and tactfully
- Ability to inspire and motivate teams and individuals
- Strong Interpersonal (listening, written and verbal communication) and presentation skills
46
Lead Etl Developer Resume Examples & Samples
- Design, Code, Test, and Document complex transformations of data being loaded to the Data Warehouse
- Function as Technical Lead to junior resources or our off-shore development team
- May translate Functional Specifications into Technical Design Specifications for off-shore development team
- May be asked to tune SQL statements to ensure optimal performance
- Provide input on physical database design decisions
- Trouble shoot and problem solve data integrity issues
- Maintain documentation in corporate data dictionary
- Contribute to physical database design
- May provide 24 x 7 production support
- Understanding of Dimensional Modeling design principles
- Knowledge of Extract, Transform, and Load (ETL) concepts, and working knowledge of some 3rd party ETL tool
- Knowledge of DataStage and Job Control Language (JCL) a plus
- Scripting skills (Shell, Bash, REXX) a plus
- 3 - 5 years of related experience
47
VP-ab Initio ETL Developer Resume Examples & Samples
- Design & develop custom ETL components using Oracle database, Talend and UNIX scripts
- Design & develop batch using AUTOSYS
- Maintain non-production Talend environments and keep in sync with production
- Maintaining all required technical documentation for Talend Implementation
- Ability to work with global development team with solid problem solving, decision making and analytical skills
- Prior 5 years of experience working as a Talend system engineer is strongly desired
- High Proficiency of Talend environments management in terms of installations and upgrades
- High Proficiency of Talend ETL Development
- High Proficiency in Unix Linux/Solaris environment and K-shell scripting skills
- High Proficiency in Oracle database development
- Good understanding of AUTOSYS batch scheduling tool
- Good understanding of PL/SQL
- Good understanding of Data Warehousing methodologies
- Bachelor’s degree in Computer Science or 8-10 years of experience in Information Technology
48
ETL Developer Resume Examples & Samples
- Understand business analytics requirements and translate them into solutions that provide optimal user experience
- Design and Develop ETL jobs using Datastage
- Provide Solution Performance (analysis/tuning) and work across business/technology teams to ensure alignment between business solution definition & systems architecture for the organization
- Collaborate with Business Users to configure data services to extract, transform and load data
- Document reporting / analytical solutions and provide support during testing, end-user training and deployment
- Perform data profiling using information analyzer,qualitystage (datastage)
- Computer-related or Engineering-related four year College or University Degree (or equivalent)
- 4 to 6 years of progressively responsible IT job-related experiences in ETL
- 3-4 years of experience in Information Server (DataStage)
- Experience with a Distributed Scheduling Tool
- Experience with Application Development Lifecycle/Methodology
- Experience with Information Analyzer,Qualitystage ( Datastage)
- Experience in Teradata utilities (M load, Bulk load, Fast load)
- Experience in BTEQ scripts
- Experience in PL SQL statements
- Experience with Quality Stage
- Experience with ETL into IBM MDM tools
- Experience with Tidal or DataStage Scheduler
- Ability to work independently and in a dynamic team environment
- Exposure to manufacturing industry
49
Microstrategy ETL Developer Resume Examples & Samples
- The gathering and interpretation of Brand Management business requirements
- Partnering with our IT teams for the technical implementation and rollout of MicroStrategy reports
- The delivery and interpretation of insights for immediate and future campaign optimizations
- Understanding the Reebok business goals and the role that Brand Management plays within that
- Supporting the Brand Management Team in defining strategies to support the overall Reebok business goals
- Leading the brand management team to identify KPIs to track the strategy progress
- Build, support and operate the MicroStrategy reports needed to track the strategy progress
- Partner with the web and social analytics team to produce combined reports for data that cannot be retrieved from MicroStrategy
- Interpret the reports and provide immediate and long term recommendations for marketing changes to improve the KPIs
- Partner with our Global IT team on long-term projects for ensuring data availability through MicroStrategy
- Loading off offline data into the Reebok Global Consumer Database
- Extraction of consumer data from the Reebok Global Consumer Database
- Consumer Segmentation in MicroStrategy
- Degree in IT, Business IT or a related field preferable
- Understanding of digital technologies/methodologies
- Knowledge of MicroStrategy, Adobe Campaign, ETL Tools like Pentaho, PL/SQL, Visio Studio, Eclipse
- Experience in a multi-country digital deployment preferred
50
ETL Developer Resume Examples & Samples
- Manages development and testing tasks and ensuring adherence to previously agreed to timelines communicating status
- Bachelor’s Degree in Computer Science or related field required
- 7 - 10years of experience at Enterprise-level ETL development and ETL architecture using Informatica and understanding the COBOL file structures
- Strong Teradata technical knowledge in the areas of general SQL
- Good knowledge of Erwin model generation tools (logical and physical)
- Performance tuning and end-to-end lifescycle experience with Enterprise wide data warehouse
51
ETL Developer / Analyst Resume Examples & Samples
- Develop and support data integrations for various entities within the healthcare enrollment data exchange space
- You will work closely with senior staff to develop your relevant technical and operational skillset
- Strong problem solving skills and attention to detail
- Strong knowledge of Microsoft Office tools
- Familiarity with data mapping formats and standards such as X12/834
- Understanding of FTP and other file transfer technologies and concepts
52
Oracle / ETL Developer Resume Examples & Samples
- Work closely with the clients to understand and finalize the requirements
- Play a lead role to facilitate the full product life cycle of new requests as necessary. This includes design technical solution, writing of detailed specifications, performing code reviews, coordinating code migrations, managing the user acceptance testing, ensuring successful migration to production
- Maintain awareness of current technology trends in the data warehousing
- 5+ years of Oracle experience with strong fundamentals in performance and tuning, efficient SQL writing, stored procedures/PLSQL coding etc
- 5+ years of Informatica experience with fundamentals in workflow, transformation etc
- 6+ years of industry experience in information technology. Data-warehousing experience is a strong plus
- Hands on experience with Autosys tool is a plus
- Ability to work late evening / early morning hours as and when needed for production support as well as interacting with
53
ETL Developer Resume Examples & Samples
- Working as a part of a team to deliver quality and robust solutions in a demanding business environment
- Participating in process improvement initiatives
- Responsible for delivering to agreed constraints in terms of time and scope
- Managing time accordingly across multiple simultaneous projects with differing priorities
- Working closely with the business and technical stakeholders to deliver innovative and quality solutions
- Ensuring Macquarie's IT security, risk, audit and compliance frameworks are followed
- Contributing to the continuous improvement of IT processes and tools in the team
54
Advisory ETL Developer Resume Examples & Samples
- Quickly understands the business issues and data challenges of Manheim business and industry
- Identifies strengths and weaknesses in existing processes, suggests areas of improvement, and helps enhance existing ETL processes to meet evolving requirements
- Understands and review technical requirements, designs ETL process flow and walkthroughs and performs data profiling of required source systems
- Provides oversight of other ETL development activities and unit testing all objects and processes, and performs find-tuning and UAT issue resolution
- Assists in enforcement of project deadlines and schedules
- Help BI reporting developers with analyzing data source, designing, testing and implementing Analytics reports and dashboards
- Exhibits confidence and an extensive knowledge of emerging industry practices when solving business problems
- Mentors ETL Developers on the best practices and provides feedback/comments during ETL code reviews
- Seeks and participates in development opportunities above and beyond training
- Minimum of 12 years of working experience with Informatica PowerCenter in BI/Data Warehousing space or system integration work
- 3 years of working knowledge of OBIEE tool and understand how it interacts with other applications
- Working knowledge and experience with ETL/Data integration using Informatica and DAC
- Prefer previous team lead or Technical Architect responsibility for ETL development
- Experience in using SAS for development is a plus
- Solid working knowledge in cloud based integrations
55
ETL Developer Resume Examples & Samples
- Responsible for design, development and implementation various tasks in building data warehouse and complex ETL process
- Experience in developing ETL process for loading stage, ODS, Data Marts and change data capture with sound knowledge of various aspects of data warehouse build process from scratch
- Understand the business requirements, design and develop ETL process
- Responsible for loading data into Data Warehouse and Data Marts. Should be able to schedule, maintain the refresh jobs
- Design and develop database objects using mysql or any other RDBMS
- Troubleshooting/debugging data issues and provide detailed Analysis on issues
- Constantly update technical knowledge, skills and learning new technologies
- 5+ years of experience in Data Warehousing, with in-depth knowledge of dimensional modeling required
- Extensive experience in ETL development and hands on ETL tools administration preferred
- Experience in Business Intelligence development, using Pentaho BI (PDI) or any other ETL tool is required
- Strong experience in design, development, testing, enhancement and performance tuning of complex ETL processes is required
- Strong experience in database development (including extensively developed and tuned complex stored procedures) with mysql database or any RDBMS with in-depth knowledge of analytical functions required
- In-depth understanding SQL performance tuning
- Experience in installation, configuration and administration of RDBMS, ETL Tools preferred (good to have)
56
ETL Developer Resume Examples & Samples
- Strong knowledge of a scripting language (Python, Perl, Unix Shell or PHP)
- Experience with UNIX text searching/parsing commands (grep, sed, awk, etc.)
- Experience with one or more of the following financial file formats: SWIFT, FIXml, Murex XML and FpML
- Experience with an ETL workflow
- Experience with test driven development practices
- Knowledge of Visual Basic and XML
57
Risk-etl Developer Resume Examples & Samples
- Must have 7+ years of experience with Informatica ETL Tools / PowerCenter 9.1, databases, developing and tuning Informatica and database code
- Ability to design, code and unit test complex Informatica transformations and mappings
- Knowledge in SQL and SQL Tuning - Understand existing code and make tweaks as needed
- Strong UNIX/Linux experience preferred
- Experience with Autosys Job Scheduler
- Knowledge on dimensional modeling a plus
- Work on multiple, concurrent tasks
- Able to / experience with managing a team of developers
- Work within formal Change Management methodologies and excellent documentation skills
58
ETL Developer Resume Examples & Samples
- Provide production support for the assigned applications
- 3 to 5 years of experience developing with ETL (Extract, Transform, Load) in large data volume environments
- Excellent UNIX/Shell Scripting experience
- Strong knowledge and experience with SQL, UNIX/AIX, Java/J2EE, XML, MQueue, SOA, WebSphere, Rational suite, UML, Schedulers and HP Quality Centre
- Excellent knowledge of DB2 and experience supporting large, mission critical databases including performance tuning
- Excellent time management and organization skills with the ability to work on competing priorities concurrently
- Experience delivering solutions using the iWay Tool Suite/MDM is highly desirable
- Knowledge of retail banking products and services is a nice to have
- Experience delivering integration or enterprise service bus (ESB) solutions is a nice to have
59
Datawarehouse ETL Developer Resume Examples & Samples
- Experience on Data warehousing applications preferably with a bank or financial Institution using Ab Initio. Any other ETL tool knowledge is advantage
- Experience in managing end to end process involving Planning, understanding Business requirements, Preparing FRD, UAT setup, Change control process and Production Rollouts
- Excellent communication skills – verbal and written in English
- 3+ years of experience in technical role with
60
ETL Developer Resume Examples & Samples
- Designs, codes, tests, debugs, installs, documents and maintains moderately complex software applications
- Validate and transform data extracted from structured and unstructured data inputs, databases, and other repositories, using scripts and other automated capabilities, logs, and queries, as required. Demonstrate in-depth understanding of fundamentals of requirement/specifications gathering, database technologies, ETL programming, and EDW data warehousing technologies
- Produces the required analysis and application design, either individually or by actively participating in development process. Responsible for creating and maintaining data maps, design specification documents, technical requirements documents (TRDs) and standard operating procedures (SOPs) in accordance with internal and external standards
- Collaborate with BI developers, DBA, researchers, and IT in enhancing existing projects or data structures, and resolving project and programming issues. Supporting database issues for development team
- Act as a subject matter expert for the ETL architecture for the EDW. Primary technical owner for the ETL Processes
- 15% Designs, codes, tests, debugs, installs, documents and maintains moderately complex software applications
- 15% Produces the required analysis and application design, either individually or by actively participating in development process. Produces design specification documents
- 15% Translates design specifications into ETL programming
- 10% Interacts with users to determine their software application objectives, scope and requirements
- 10% Develops test data and routines required to test and revise application(s). Ensures application(s) is thoroughly tested before release. Writes reports of test results
- 10% Detects, defines and debugs programs whenever problems are reported or encountered
- 10% Prepares developer and end-user documentation for other programmers and users in accordance with internal and external standards
- 5% Trains users and programmers as required
- 5% Provides leadership, guidance and direction to other programmers, as needed. Reviews the work of others, as requested
- <5% Supports DBA/Integration functions on a backup/cross-training basis
- <5% Stays informed of new developments and technologies by reading journals and other pertinent publications, maintaining contact with vendors, and participating in professional organizations, meetings and seminars
- <5% Performs other duties as assigned or requested. The university reserves the right to add or change duties at any time
61
Business Intelligence ETL Developer Resume Examples & Samples
- Participating on high-impact initiatives involving business, technology and external partners
- Providing technical support and assistance with identifying and prioritizing technology education needs, determining project parameters, and ensuring quality education solutions are implemented
- Staying abreast of industry best practices, emerging technologies and LOB/client direction to anticipate and accommodate shifts in the business need and priorities
- Conducting technical training evaluation to identify program impact, return on investment, and areas of improvement
- Serving as an Oracle application development consultant for CAO CLO Instructional Design staff, critically evaluating, testing and potentially delivering Oracle PL/SQL Developer, DBA and APEX training in support of firm-wide Oracle curriculum development and delivery
- Designs, analyzes, develops, codes, tests, debugs and documents programming to satisfy business and data quality requirements
- Formulating and defining system scope and objectives through research and fact-finding to develop or modify complex information systems
- Preparing detailed specifications from which programs will be written
- Work independently on most phases of applications systems analysis, programming activities and testing
- Working directly with internal customers, including senior executives, developing a solid understanding of the business problem for which the applications are being designed
- Assisting internal customers with questions regarding the functionality of applications
- Working off-hours and weekends occasionally, as required by project work, systems maintenance, and staffing
- Proficient in all phases of the software development lifecycle
- Minimum of 5 years experience developing software solutions utilizing agile software development methodologies
- Minimum of 3 years experience modeling data structures for applications
- Experience in writing software requirements, design specifications, and design and documentation of system test plans
- Demonstrated experience in working with business analysts & key technology partners to identify solutions to their reporting needs, develop new workflows & modify existing workflows
- Ability to assist in the definition of the database requirements, analyze existing models and reports looking for opportunities to improve their efficiency, and resolve technical problems
- Experience with Business Intelligence reporting and visualization tools (e.g., MS Excel, Business Objects, QlikView, Tableau, Cognos)
- Minimum of 5 years experience developing SQL*Plus and PL/SQL solutions
- Minimum of 5 years experience performing operational support of applications that utilize Oracle technologies
- Minimum of 3 years experience with the UNIX operating system, preferably on Linux platforms, using Korn Shell, AWK, SED, and common system functions
- Ability to work independently, and escalate issues and seek guidance as necessary
- Deliver all work products to defined best practice standards and ensure high quality results
- Demonstrated use of system application skills that include programming logic, system analysis, system testing, documentation, troubleshooting, and user support
- Oracle APEX (Application Express) development experience
- Exceptional data analysis skills and problem solving ability
- Sharepoint development experience
- Technical content delivery experience
- High comfort level with all standard Microsoft Office development tools
- Excellent communication skills with the ability to communicate (oral, written, and active listening) to all levels of the business
- Strong customer service skills and demonstrated ability to build professional relationships
- Solid teamwork and interpersonal skills - able to work alone or with a team
- Capable of dealing effectively with change
- Extremely well organized
- Highly motivated individual who can work in a fast paced environment
- Ability to participate in the analysis and/or resolution of IT and business issues
62
ETL Developer Resume Examples & Samples
- In-depth knowledge of data warehouse, operational data store, data marts, reference master data repositories
- In-depth knowledge of database concepts
- Data profiling experience, Prepare Functional specifications document(s), Data quality analysis
- In-depth knowledge and hands-on experience with ETL Informatica development, Performance tuning
- Data analysis and database design, database tables, views, functions creation experience
- In-depth knowledge and hands-on experience of RDBMS systems, specifically Sybase, Teradata, DB2
- Strong Communication skills, co-ordination skills
- Experience in Oracle Database design, development
- One or more Informatica Data Quality/Analyst, Business Objects, Qlikview development
63
Senior Data Integration / ETL Developer Resume Examples & Samples
- Responsible for the efficient, compliant, timely, and secure acquisition, integration, provision, and exchange of the enterprise data
- Provide data integration architecture leadership across the enterprise
- Work with external vendors and internal business and technology staff to accurately gather and interpret requirements, specifications, and database models to determine appropriate ETL development solutions
- Develop ETL technical specifications and recommend, design, develop, test, implement, and support innovative and optimal data solutions
- Develop and document technical best practices for ETL-related activities including data movement, data aggregation, data quality, and data cleansing
- Work with the Data Warehousing and Business Intelligence team to design, implement, and support end-to-end data solutions across multiple platforms, environments, domains, and locations
- Integrate ETL development with existing codebase to maximize object reuse
- Document ETL processes, programs and solutions as per established standards
- Perform tasks required to conform to the company’s configuration management and software release processes
- Work with internal staff, vendors, consultants, and external partners to quickly identify and resolve data integration and ETL job issues
- Assess and document the structure, quality, and compliance of data source data and coordinate with business and technology staff to identify and resolve issues
- Mentor other Data Services team members in the ETL tools, programs, processes, and best practices
- Bachelor's Degree in Computer Science or Mathematics. Work experience as a senior ETL developer in an enterprise business environment may be considered equivalent
- Minimum 6 years experience designing, developing, testing, and implementing ETL solutions using enterprise ETL tools (experience with IBM DataStage/QualityStage is preferred)
- Minimum 6 years experience developing and implementing data integration and DW solutions in an Oracle 11g/12g database environment (experience with Netezza preferred; experience with DB2 is a plus; experience with Oracle EBS is a plus; experience with Salesforce is a plus)
- Minimum 2 years experience working with BI tools (IBM Cognos is preferred)
- Minimum 2 years experience working in a SOA environment
- Minimum 2 years experience working with high volume data exchange and transaction processing systems, preferably in a custom software development environment
- Minimum 1 year experience in 10+ TB data environment
- Minimum 2 years experience integrating large (100M+ rows) structured and unstructured data in multiple formats, character sets, and delivery methods
- Expertise in RDBMS, Data Mart and Data Warehouse design. Knowledge of data modeling, MDM, BI, and CRM is preferred
- Expert-level SQL and PL/SQL development skills in a multi-tier, SOA environment are required. Experience with advanced features such as PL/SQL analytic functions is highly preferred
- Expertise in flat file formats, XML within PL/SQL, and file format conversion
- Expertise in web services development
- Strong understanding of SDLC and Agile Methodologies
- Strong understanding of Model Driven Development
- Expertise and hands-on experience with design and development best practices
- Ability to handle multiple projects and deadlines with minimal supervision
- Dedicated to excellence in one’s work; detail-oriented and thorough
64
Intermediate ETL Developer Resume Examples & Samples
- Manage and participate ‘hands-on’ in the implementation by analyzing user requirements, providing technical specifications and designs, developing detailed work-plans, scheduling technical resources, monitoring progress against plan and developing/maintaining programs according to standards. The incumbent must ensure software, programs and applications developed and/or configured to meet high availability, integrity and reliability requirements
- Work within a development team to develop application programs that work with web and UNIX technologies using iWay Service Manager, Java, servlets, XML, HTML, JSP's, JavaScript, Web Services, Master Data Management Technology, and Mainframe/Host Technology Integration
- Participate in the development of application systems through to implementation
- Participate in the delivery of the negotiated function to the user while following BNS standards and methodology
- Provide technical expertise, guidance, advice and knowledge transfer to all development staff on all aspects of application development for assigned applications or technology
- Provide production and user acceptance testing application support to complex technical problems on all assigned applications and technology that serve each business unit by analyzing problems, implementing solutions and developing new procedures surrounding support
- Implement new systems or enhancements by reviewing programs written by team members, establishing and executing system test procedures, developing implementation plans, developing the required program and system documentation and ensuring all functionality has been delivered as required. The incumbent is also required to provide post implementation support and training to the support staff on production processing functionality
- 1-3 years of experience developing with ETL (Extract, Transform, Load) in large data volume environments
- UNIX/Shell Scripting experience
- Working knowledge and experience with SQL, UNIX/AIX, Java/J2EE, XML, MQueue, SOA, WebSphere, Rational suite, UML, Schedulers and HP Quality Centre
- Excellent interpersonal and communication skills in order to effectively liaise with business users, members of project team, and technology partners
65
ETL Developer Resume Examples & Samples
- Develop cost effective and efficient applications to meet business objectives by analyzing user requirements, providing technical specifications and design and developing/maintaining programs according to standards. The incumbent must ensure programs and applications developed meet the high availability, integrity and reliability of the on-line transaction processing environment
- Provide production and user acceptance testing support to assigned applications by identifying, evaluating, escalating, resolving problems and supporting other team members. The incumbent is required to carry a beeper approximately 50% of the time to ensure systems support is readily available and that systems are operational according to documented user service level agreements
- Implement new systems or enhancements by reviewing programs written by team members, establishing and executing system test procedures, developing implementation plan, developing the required program and system documentation and ensuring all functionality has been delivered as required. The incumbent is also required to provide post implementation support and training to the computer operations staff on the production processing functionality
- Assist project leader or Manager by supervising more junior staff, providing backup support to the Project Leader or Manager, assisting with the development of detailed workplaces and monitoring progress against plan
- Keep current on rapidly changing technological trends, self teach new technologies and maintain an understanding of the Division’s business and technology strategies
- Experience using multiple operating platforms, such as UNIX and Linux
- Strong Relational Database experience; DB2 preferred
- Strong understanding of business systems analysis and development, and working knowledege of data processes and Reporting /Business Intelligence solutions
- Excellent analytical, problem solving and trouble shooting skills in order to develop and support systems to meet user requirements. The incumbent must be creative and flexible in identifying technical solutions to resolve business problems in a rapidly changing, demanding and complex business environment
- Excellent interpersonal and communication skills in order to deliver proposals, provide user support and interact with team members and other departments
- Good debugging, testing, coding, and productivity tools experience
- Banking or Financial industry experience is a nice to have
66
Etl-developer Bangalore Resume Examples & Samples
- Architect, design and implement and test back-end components of an n-tier application, including data model, data access objects, and application logic
- Minimum of 5-7 years of experience in Application Development using Informatica
- Minimum of 5-7 years of experience in writing SQLs (Proficiency in Stored Procedures, Triggers, Batch processing and Performance tuning is a must)
- Minimum 5-7 years of experience with ORACLE (Sybase also is a plus)
- Strong technical, analytical, problem solving, and communication skills
- Experience with SVN Source Code management techniques/ tools for software management, Knowledge SDLC tools (JIRA)
- Experience in Investment Management Technology applications preferred
67
ETL Developer Resume Examples & Samples
- Conducts research into new data warehouse applications and determines viability for adoption
- Assists in several components of the overall architecture of the data warehouse system
- Performs quality assurance testing of data integration and report development. Monitors data load operations to ensure accuracy
- Assists and/or provides limited direction to lower level technical personnel
- Five or more years of experience in data management or computer programming
- Experience working with company database and statistical software
- Experience working with data warehousing standards, strategies, and tools, preferably Datastage
68
ETL Developer Resume Examples & Samples
- Develops internal systems for data integration and reporting
- Conducts analysis and gathers requirements from internal stakeholders and customers
- Maintains communication with internal stakeholder on progress and deadlines
- Establishes excellent working relationships and promotes teamwork within geographically dispersed teams
- Accountable for delivering on commitments and managing time effectively with minimal supervision
- Three plus years of database or ETL development using either SQL Server, SSIS, MySQL or Redshift
- Experience with performance-tuning and troubleshooting
69
ETL Developer / Consultant Resume Examples & Samples
- Ability to travel and work at the client site
- Proven communication skills both with client and internally
- Excellent presentation and documentation skills.Yes
70
Database / ETL Developer Resume Examples & Samples
- Perform enhancements to existing applications
- Candidates should note that this list is not exhaustive and duties are liable to change from time to time in line with the
- Strong OOP development experience, E.g. Java, Spring, Hibernate, Java Script like JQuery, extJS, Web services
- Knowledge of MS SQL Server or Oracle or DB2 including complex queries, DDL/DML and stored procedures
- Knowledge on webservers like IBM Websphere ,or BEA Weblogic or JBOSS or Tomcat
- Proficient at UNIX Solaris/Linux and MS Windows. UNIX Shell Scripting
- Good understanding of full software life cycle development processes and Configuration Management SVN
- Knowledge of Financial sector is a plus
- Excellent analytical, communication and co-ordination skills
- Excellent Java designing skills - Design patterns
71
Business Intelligence ETL Developer Resume Examples & Samples
- Extract and manipulate data to be used in presentable reports and analytical tools
- Develop productivity models to be used in performance management
- Develop predictive models to complement intraday forecasts and support capacity planning activities
- Define business rules for new metric development
- Understand work drivers in the customer facing groups
- Recommend time utilization plans based on forecasts
- Produce and communicate results on a monthly / weekly basis
- Prepare presentations for the senior management team
- Ad-hoc analysis
- Must be proficient in MS PowerPoint and advance skills in MS excel
- Experience using SQL
- Exceptional writing, communication, and presentation skills
- Highly analytical and curious
- Proven experience in working with load predictions and completing statistical analysis
- Demonstrated problem solving skills
- Ability to influence internal and external teams
- Confident and demonstrated strong leadership
- Ability to adapt to a fast paced environment with high tolerance to change management
- Comfortable in working in a virtual environment (i.e. conference calls)
- Self motivated, autonomous
- 2 years of customer facing (call centre) management experience in service provisioning or a service assurance field
- Experience with Visual Basic for Applications (VBA)
- Experience using ETL management tools such as SAS, EG, or PENTAHO
- Experience creating performance dashboards and scorecards using business intelligence dashboards (i.e. Cognos, MicroStrategy, Tableau, or MS Excel)
- Bilingualism is an asset (English and French)
72
Finance ODS ETL Developer Resume Examples & Samples
- Adherence to Development Life Cycle, IT controls and change control policies for all developments
- 4-5 years of experience of Java development
- Good understanding of database development and SQL queries
- Experience of Unix scripting
- Experience in Agile/Iterative development methodologies, with an aspiration to learn and work on new technologies
- Informatica or any other ETL tool experience would be beneficial
- Cognos report development experience would be beneficial
- Experience of working with Autosys scripting would be desirable
73
ETL Developer Resume Examples & Samples
- Good English skills, both verbally and in writing
- Websphere Message Broker
- DB2, SQL
- Lotus Notes interfaces to Data Stage
- FileNet experience
- FTP
- PureXML it is must have for the other one
- Websphere Application Server
74
ETL Developer, Senior Resume Examples & Samples
- Manages development resources by assigning design, development and testing tasks and ensuring resource adhere to previously agreed to timelines communicating status
- Evaluates the integration a various data sources like Oracle, SQL server, VSAM and sequential files into staging area and recommends and/or implements efficiencies
- Develops ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc
- Implements data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets
- Understand reusability, parameterization, workflow design, etc
- Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions
75
Datawarehouse ETL Developer Resume Examples & Samples
- Work on key development projects ensuring timely delivery
- Participate in technical discussions representing EMEA finance technology
- Work closely with other IT development function and ensure all deliverables from the requirements are met
- Interface with Finance and Regulatory business analysts and translate business requirements to Functional and technical specifications
- Adhere to SDLC and Software Quality standards always
- Oracle (Sql, Plsql)
- Good working knowledge of Project lifecycle methodologies
- Experience on Data warehousing applications, preferably with a bank or financial Institution using Ab Initio. Any other ETL tool knowledge is advantage
- Strong knowledge of English
- Ability to develop relationships with peers in business unit and risk management groups
- Skills to handle multiple work streams and ad-hoc tasks simultaneously
76
ETL Developer Resume Examples & Samples
- Component Software Design & Development
- Participating in agile development projects
- Mentoring technical development team on optimal utilization of Big Data solutions and Apache Open Source Software
- B.S. in Computer Science
- Experience Delivering End to End Solutions in the Enterprise Space
- Fluency in Java is required
- Strong foundation of OO Design & Enterprise Architecture, Design Patterns, and Unit Testing
- Experience going from whiteboard concept to delivery of Service Oriented Architecture
- Experience with Database integration
- Experience with Linux platforms
- Experience with MPP platforms
- Experience with Hadoop and Map/Reduce development
- Experience with NoSQL technologies is a plus
- Experience with Name-Value and Columnar data stores is a plus
- Ability to work with the team and the business to identify business problems and design excellent solutions
- Experience in multi-threaded application development
- Experience with large data processing solutions
- Experience with Data Virtualization Solutions is a plus
- Experience with application development frameworks
- Knowledge with Maven and Jenkins
- Excellent quantitative and analytical skills
- Proven ability to prototype and develop in short cycles
- Excellent intuition as to how to design and implement distributed systems for Enterprise use
- Ability to work well independently
- Ability to develop use cases and software test plans
- Ability to properly stress test software
- Ability to work productively and efficiently in an agile environment
- Proven ability with R&D activities
77
ETL Developer Intern Resume Examples & Samples
- Collaborate with product development teams and senior designers to develop architectural requirements to ensure business requirements are met
- Develop & unit test Informatica ETL processes for optimal performance
- Maintains responsibility for unit testing and collaborates with other IT staff to ensure smooth deployment and ongoing management of the product
- Major: Computer Engineering, or a related field
- Experience with Informatica Metadata Manager (9.1 or above) to capture technical and business metadata and build out data lineage
- Expert in data warehousing methodologies and best practices required
- Plus-experience with Hadoop, MAP-R and Big Data
- Ability to work independently and in group settings
- Desire to enter the Media / Technology / Advertising industry upon graduation and passionate about innovation
78
Junior ETL Developer Resume Examples & Samples
- Design/development of enhancements for the existing flows
- Design/development of new functionalities/flows
- Ability to understand and develop business requirements and create design to meet those business requirements
- Development experience in IBM DataStage is a plus
79
ETL Developer Resume Examples & Samples
- Works with external vendors and internal business and technology staff to accurately gather and interpret requirements, specifications, and database models to determine appropriate ETL development solutions
- Develops ETL technical specifications and recommends, designs, develops, tests, implements, and supports innovative and optimal data solutions
- Works with the Data Services and Business Intelligence team to design, implement, and support end-to-end data solutions across multiple platforms, environments, domains, and locations
- Integrates ETL development with existing codebase to maximize object reuse
- Performs tasks required to conform to the company’s configuration management and software release processes
- Monitors and administers ETL jobs to verify execution and measure performance
- Works with internal team, vendors, consultants, and external partners to quickly identify and resolve data integration and ETL job issues
- Assesses and documents the structure, quality, and compliance of source data and coordinate with business and technology teams to identify and resolve issues
- Minimum three years experience designing, developing, testing, and implementing ETL solutions using enterprise ETL tools (experience with IBM DataStage/QualityStage is preferred)
- Minimum two years experience developing and implementing data integration and DW solutions in an Oracle 11g/12g database environment (experience with Netezza preferred; experience with DB2 is a plus; experience with Oracle EBS is a plus; experience with Salesforce is a plus)
- Minimum one years experience working with high volume data exchange and transaction processing systems, preferably in a custom software development environment
- Understanding of Oracle RDBMS
- SQL and PL/SQL development skills in a multi-tier, SOA environment are required
- Proficient in flat file formats, XML within PL/SQL, and file format conversion
- Proficient in web services development
- Understanding of SDLC and Agile Methodologies
- Understanding of model driven development
- Understanding of ETL best practices
- Hands-on experience with design and development best practices
- Proficient in working with technical and business teams to extract and document data integration/exchange requirements
80
ETL Developer Resume Examples & Samples
- Develop ETL and related components as specified in the design, functional and non-functional requirements within established time and quality standards
- Perform unit testing of ETL and related components and document test results
- Conduct or participate in code reviews to ensure quality, standards compliance, reusability and ease of maintenance
- Correct testing defects and support all testing phases
- Participate in maintaining the integrity of the source code by applying the appropriate retrofitting (in-flight projects) timely and using a version control tool
- Participate in the deployment preparation tasks such as packaging and documenting deployment instructions
- Support a positive work environment that promotes service to the business, quality, innovation and teamwork and ensure timely communication of issues/ points of interest
- Work effectively as a team, supporting other members of the team in achieving project/business objectives and providing client services
- Participate in knowledge transfer within the team and business units and keep current with leading-edge technologies trends
- Continuously enhance knowledge / expertise in own area and keep current with leading-edge technologies trends
- Identify and recommend opportunities to enhance productivity, effectiveness and operational efficiency of the business unit and/or team
81
ETL Developer Resume Examples & Samples
- Experience in SDLC- Waterfall / Agile
- Experience in environments like Unix, Linux, Windows IIS, Data Warehouse (DHW) etc
- Working knowledge in application design concepts
- Working experience in C++ is a plus
- Able to contribute to Automation, Causal analysis and Develop shared/common solutions
82
ETL Developer Resume Examples & Samples
- Work with the business end users to understand requirements and come up with a solution within the team
- Analyzing and documenting problems, recommending solutions, and initiating corrective action
- Minimum 4-5 years of financial application development/consulting experience including Reconciliation business
- Hands on development knowledge of Informatica
83
Lead Integration / ETL Developer Resume Examples & Samples
- Troubleshoot, optimize and tune ETL processes
- Determine the structure of data; experience in data analysis
- Handle multiple work related tasks
- Plan and coordinate project work stream development and deployment
- Manage assigned resources per company’s methodology and processes
84
Senior Integration / ETL Developer Resume Examples & Samples
- Build, review and analyze the ETL requirements
- Document all ETL related work per company's methodology
- Develop mapping / sessions / workflows
- Write and optimize SQL code (TERADATA 12.x AND ORACLE, 10 or 11 a MUST) and stored procedures
- 24x7 On-Call Support Rotation
85
Oracle Data & ETL Developer Resume Examples & Samples
- Consult with other business areas to create cost benefit analyses and prioritize current projects
- Collect, analyze and communicate competitive intelligence to influence network development strategies
- Support technical analysis by maintaining databases of network cost and competitive intelligence data and developing data extracts for routine and special studies
- Prepare and present recommendations to both internal and external audiences
- Resolve general issues and defects within Infra (Humana's Service Operations Issue Tracking system)
- Bachelor’s degree in Information Technology, Business, or related fields
- Prior experience in data management, data extraction and data reporting
- Comprehensive knowledge of relational databases and programming
- Comprehensive knowledge of ETL tools and data integration methodologies
- Oracle 12c or Exadata SQL tuning knowledge
- Informatica’s PowerCenter development knowledge
- SSIS and SSRS development experience
- .Net w/MVC or Java UI development is a plus
- Experience with healthcare information technology
86
ETL Developer Resume Examples & Samples
- Collaborating with business users, solution vendors, and IT service managers, to define solution requirements for data acquisition, apply transformations, determine data quality, enforce data integrity, and define destination repository structures
- Acting BODS administrator responsible for setup of new users, client environment, managing configuration parameters for adapters, and working closely with SAP system administrators
- Production support for existing ETL applications involving debugging, data analysis, change management, and support documentation
87
Graduate ETL Developer Resume Examples & Samples
- Bachelor or Master degree (Mathematics, Computer science, Information Technology, Engineering, Economics, Management)
- A Graduate professional with relevant experience 0-2 years after university graduation
- Understanding of Oracle PL/SQL and/or MS SQL T-script
- The right attitude, Communication, Creativity, Problem Solving, Taking Ownership, Teamwork and Collaboration
- Flexibility to travel in Slovakia, as well as internationally
88
ETL Developer Resume Examples & Samples
- Gathering, documenting, examining and managing data integration and data management requirements in an Agile/Scrum development team
- Building extensible data acquisition and integration solutions using various integration tools (Informatica, Pentaho, Ab>Initio, IBM DataStage, Kafka, Flume, etc.) and a variety of data environments (Hadoop, Oracle, Mongo, etc.)
- Optimising data integration platforms to provide optimal performance under increasing data volumes and complexity
- Creating test plans and scripts for data integration/data model testing, ranging from unit to integration testing
- Liaising with other technical areas, conducting technology research and evaluating software required for maintaining the data management environment
89
ETL Developer Resume Examples & Samples
- Minimum 2 years development experience
- Bachelor’s degree in Computer Science or equivalent discipline
- ETL - Ab Initio GDE and Co>Op
- UNIX/Linux Shell scripting
- Oracle concepts, SQL, PL/SQL
- SQL performance tuning
- Java SE
- Prior industry experience with Reference Data
- Java EE: Servlets, JSP and EJB
90
ETL Developer Resume Examples & Samples
- Perform source to target data mapping
- Review and assess business rules, project plans, development and test specifications
- Plan, schedule and coordinate changes internally and externally
- Provide on-going maintenance and support of production ETL processes. Monitor production processes and respond to errors and emergency issues
- Collaborate with business units to provide information as appropriate
- Skills:This job requires advanced knowledge and expertise in commercial software, tools and systems required to develop and maintain ETL. Additionally required are skills in analysis, critical thinking, problem solving and trouble shooting, oral and written communications and presentation and expertise in data profiling and data quality concepts and techniques
- Responsible for design, develop and maintain ETL jobs using the tool
91
Senior Oracle / ETL Developer Resume Examples & Samples
- A challenging position with responsibilities to develop and test robust software for the Treasury DWH
- Working on high-visibility projects related to regulatory and business requirements especially in the area of Liquidity Management
- The chance to learn datawarehousing technologies in a complex and time-critical environment
- Working in an agile environment
- Communication with the different teams within Credit Suisse
- Involvement at a global level in a multi-cultural team
- Ensuring that common standards, processes and tools are adopted across own deliverables
92
ETL Developer Resume Examples & Samples
- Solid knowledge of the UNIX/Linux environment
- Knowledge of RDBMS
- Interest in learning KDB/q
- Informatica Power Center 9.x
- Strong communication skils to be a liaison between Asia users/program management and developers
- Knowledge of equities and fixed income securities such as stocks, indices, options, bonds, swaps, futures, repos, etc
93
CIB IS Data Platform ETL Developer Resume Examples & Samples
- Design, build and testing complex Oracle Store Procedure/ Function/SQL and UNIX scripts
- Help with the tuning existing Store Procedure/ Function/SQL
- Review AWR reports and able identify bottleneck area and work with solution
- Troubleshoot errors as they occur
- Be a subject matter expert, with knowledge of all versions Oracle DB schemas
- Used Autosys for scheduling the jobs
- Guide junior developers with best practice and tuning technique
- Ability to multi-task and comfortable with quickly switching from one task to another
- Involved in Reviewing the Code developed by other team members with in the project
- Review all the coding and naming standards
- Train other team members as needed
- 4-5 years PL/SQL development and rational Database
- 2-3+ years as Application DBA
- Experience with Oracle 11g and 12c
- Familiar with with RMAN and other Oracle backup/Restore methods
- Experience using Oracle Enterprise Manager for monitoring and maintenance
- Ability effectively tune SQL and PL/SQL queries
- Experience on projects utilizing Agile methodology a strong plus
94
ETL Developer Resume Examples & Samples
- Must be hands on ETL tools like Informatica,SAP BODS, ODI, SQL and procedural SQL languages
- Should have completed at least 1 full life cycle experience in a ETL project
- Understand and assess the Source to target map documents and provide the recommendations if any
- Must be hands on Unix scripting
- Good exposure to SSIS, SSRS, SQLServer, DB2, Oracle, Teradata
95
ETL Developer Resume Examples & Samples
- Must be hands on SQL and procedural SQL languages and ETL tools like Informatica,SAP BODS, ODI etc
- Should have completed at least 2 full life cycle experience in a ETL project using any tools like Informatica, SAP BODS, ODI
- Must have at least 4 years of deep experience in ETL tools
- One life cycle implementation using any of the Data Quality tools like SAS Dataflux or Informatica DQ would be an added advantage
- Must be able to analyse, design and develop ETL mappings, workflows
- Need to work as a Senior team member to contribute in various technical streams of EI implementation project
96
ETL Developer Resume Examples & Samples
- Design, build and unit test the DI application modules with Abinitio, DB2/scripting, K Shell scripting & Control M scheduling
- Perform development activities such as Source to target mapping validations, identify, document and execute unit test cases/scripts, peer and lead code reviews per code review checklist and document test and review results
- Be part of the ‘Run the Engine’/L2 application support activities and incident resolutions in Production
- Collaborate with BA’s, data architects, application leads, QA analyst and production support, through SDLC
- A minimum of 8 years of IT based software development experience
- A minimum of 6 years of data integration experience developing DI Applications using Abinitio or Informatica
- A minimum of 1-2 years of working experience with DB2
- A minimum of 1-2 years of experience developing Abinitio continuous flow components in support of mission critical applications is preferred
- DI architecture and data modeling experience
97
Pentaho / ETL Developer Resume Examples & Samples
- Develop and enhance software application modules specific to ETL
- Must have at least 2+ years of recent Pentaho experience
- ETL developer with data warehouse/datamart experience in the financial industry
- Experience working with Informatica, Pentaho, AbInitio or other third party ETL tools
- Good working knowledge of Unix and Unix Shell scripting
- Involvement in all parts of the project lifecycle
- Private Banking technology experience a plus
98
ETL Developer Resume Examples & Samples
- Creating Automated Unit Tests using Flexible/Open Source Frameworks using a Test Driven Development / Behavior Driven Development approach
- Digesting and understanding Business Requirements and designing new modules/functionality which meet needs
- Utilize agile methodologies and adhere to coding standards, procedures and techniques while contributing to the technical code documentation
- 7+ years of solid IT experience with at least 5+ years in Informatica
99
ETL Developer Resume Examples & Samples
- Responsible for the design, coding, testing, tuning and maintenance of DB2 datamarts and Informatica code
- Work directly with Modelers/Architects/DBA on data modeling, logical/physical schema design, SQL query tuning; and the application of data-related business rules while assisting in troubleshooting, debugging, and issue resolution
- Communicate effectively with end users, peers, and management regarding assignments, and must have a can-do attitude and a desire to provide solutions
- Provide support for the resolution of all reporting issues escalated by the Support Operations Team post-implementation
- Working with global development team to have designs implemented, tested, productionalized and present to user groups
100
ETL Developer Resume Examples & Samples
- Used Autosys for scheduling the jobs and to automate the ETL process
- Work closely with business partners throughout the requirements gathering, technical design and development lifecycle phases
- Document functional/technical specifications
- Participate in design, implementation and peer reviews
- 1-2 years of experience in IBM InfoSphere DataStage or other ETL tools (Informatica PowerCenter, Pentaho and etc)
- Analytical & trouble shooting skills required
- JAVA and WebSphere MQ strong plus
101
ETL Developer Resume Examples & Samples
- Informatica Developer will design, develop, implement and support enterprise initiatives around data integration and building a data and reporting infrastructure
- This position is primarily responsible for data analysis, Developing and maintaining Informatica ETL processes along with a rotational on-call production support responsibilities
- Create and maintain SQL Server databases, stored procedures, tables, views, and functions to support application and ETL initiatives
- Develop and maintain the database architecture for specific projects as needed
- Plan and develop data ETL procedures, and secure data transfer processes
- Utilize mature (3rd or 4th Generation) programming methodologies and languages and platforms (TM1, Java, SQL, big data- near future) and adhere to coding standards, procedures and techniques while contributing to the technical code documentation
- Incorporate Architectural Standards into application design specifications
- Translate technical requirements into programmed application modules and develop
- Identify application code-related issues
- Minimum 5+ years experience in coding, testing and or debugging skills
- Minimum 5+ years experience in informatica
- Experience working with large scale/enterprise wide Data Warehouse and Business Intelligence projects
- In depth knowledge of data mart design and dimensional modeling
- Minimum 3+ years experience in creating stored procs, tables and functions in SQL server
- Unix shell or PERL scripting experience is a plus
- Experience with other Data Integration tools like Pentaho is a Plus
- Knowledge of reporting or Analytical tools a Plus
102
ETL Developer Resume Examples & Samples
- Bachelor's degree in MIS, Computer Science, Statistics, Business or equivalent work experience
- Extensive hands on Application Development experience throughout the entire project lifecycle
- J2EE experience (SDK 7 and above)
- Gang of four and J2EE design patterns
- Experience on spring and hibernate framework
- Web development with jQuery – knowledge of Angular JS/backbone/nodejs would be an advantage
- SQL development - They will be expected to write complex queries, procedure, functions, dynamic sql that are scalable
- Have worked in Agile development environment
- Experience in working with Build management tools – Ant or Maven
- Experience on continuous integration tools like Jenkins, bug tracking tool jira, and code repository svn
- Experience on Test Driven development
- Ability to attain results, convey a sense of urgency and drive issues to closure, persists despite obstacles and opposition, sets high standards of performance and pursues challenging goals
- Strong interpersonal skills; promoting healthy relationships and team dynamics
- Customer or end-user focused and has ability to manage expectations
- Good knowledge of industry best development practices
- Familiarity with metadata tools and management
- Strong knowledge of Windows server environment
- Proven ability to work independently
- Strong leadership and influencing skills
- Knowledge of Git
- Experience on Restful webServices
- Knowledge of BDD
- Experience on Reverse proxy server like Apache
103
ETL Developer Resume Examples & Samples
- Develop, maintain, and administer complex ETL processes using MS SQL Server 2005/2008/2012 (DTS and SSIS), Ab Initio
- Provide thought leadership on data and system architecture, system administration, schedule management, performance tuning, and expansion
- Participate in ongoing DW/BI performance tuning activities
- Develop, troubleshoot and fine tune existing and new reports
- Evaluate and implement products and implement best-practices to enhance our BI/DW solution
- Provide expertise on decisions and priorities regarding the enterprise’s overall data warehouse architecture
- Facilitate the development of data integration efforts with the development team
- Expand the company’s use of data as a strategic enabler of corporate goals and objectives
- Establish methods and procedures for tracking data quality, completeness, redundancy and improvement; and processes for governing the identification, collection and use of corporate metadata to assure metadata is accurate and valid in the business intelligence environments
- Be able to define requirements, analyze data, design solutions, program, test, implement, and train end-users and fellow IT team members
- Bachelor's degree in Engineering/Science in Computer Science or Information Technology/Systems
- 3-5 years of experience developing, maintaining and administering Teradata, MS SQL Server databases
- Experience with Business Intelligence and Data Warehouse products
- Hands on ETL experience with Ab Initio
- Relational and Dimensional data models
- Strong software logic design, analytical/analysis and problem solving skills
- Excellent team player and ability to work in a highly-dynamic environment
- Excellent communications and interpersonal skills, including ability to interact and communicate within IT and Business teams
- Proven track record as a self-directed, energetic, individual contributor
104
ETL Developer Resume Examples & Samples
- Design and document ETL process for new DW subject areas
- Create data extraction, cleansing and load programs to move data into and out of the data warehouse
- Develop, implement and maintain schedule/dependency logic for automated ETL processing. Develop monitoring, logging, and error notification processes to ensure data is updated as expected and processing metrics reported
- Accountable for conforming to established architectural, developmental, and operational standards and practices including creation of ETL metadata
- Assist in the maintenance and administration of applications and software used by the ACE foundations team
- Evaluate and recommend database development tools
- Assist in application and database performance tuning
- Participate in system architecture design
- Implement integration and interface tools between transactional and data warehousing systems
- Work with quality assurance to assist with unit and integrated testing
- Share trouble-shooting and maintenance duties
- Four years experience in SQL, database programming and utilities (preferably Oracle)
- Knowledge and experience in relational and dimensional database design techniques
- Experience developing applications in Windows and UNIX operating environments
- Experience with data modeling required
- Experience with developing sound technical documentation
- Experience with data warehousing systems design and development a plus
- DataStage experience desired
- PL/SQL, Perl, UNIX desired
- Experience within the health care realm preferred
- In depth knowledge and experience with ETL development and applying sound ETL techniques and modular system design skills
- Ability to identify and resolve data quality issues within the ETL realm
- Understanding of basic DBA skills such as, physical modeling, table partitioning and indexing
- Knowledge of system architecture design
105
ETL Developer Resume Examples & Samples
- Create data extraction, cleansing and load programs to move data into and out of the Data Warehouse
- Assist in the maintenance and administration of applications and software used by the ACE Foundations team
- Work with Quality Assurance to assist with unit and integrated testing
- 5 years experience in SQL, database programming and utilities
- Excellent analytical skills required
- Previous experience with data warehousing systems design and development a plus
- Previous experience with data modeling required
- In depth knowledge and experience with ETL development and applying sound ETL techniques and modular system design skills are essential
- Experience with developing sound technical documentation is required
- Understanding of and experience with basic DBA skills such as, physical modeling, table partitioning and indexing is required
106
ETL Developer Resume Examples & Samples
- Bachelor’s degree from an accredited college or university in Computer Science, Computer Information Systems or related field
- 7+ years in IT related field
- 5+ years Data Warehousing and Business Intelligence experience
- 5+ years of technical experience relating to ETL design, development, performance and validation
- Direct experience with enterprise data warehouses
- Ability to analyze clinical and business source systems on a variety of platforms
- Experience with healthcare data from EMRs like Epic
- Experience with any type of -omic data
- Experience a variety of ETL development tools, e.g., Informatica, SSIS, Talend
- Experience with Oracle Enterprise Health Analytics or Google Cloud Platform components
107
ETL Developer Resume Examples & Samples
- 3 years' experience
- Working with ETL toolset in Enterprise Data Warehouse and with Enterprise Integrations environment
- Working with Informatica Power Center
- 1 year experience
- Working with Teradata (ETL and BTEQ scripting)
- Scheduling tools (Tidal and AutoSys)
- Working with BW/SAP extraction (ETL); and
- Working with SAP AFS data including Sales Orders, Purchase Orders, Materials and Inventory
108
ETL Developer Resume Examples & Samples
- Over all 4 to 8 years ETL experience
- Understand user requirements and provide solutions using ETL tools – Informatica power center and Teradata scripts (BTEQ/Multiload/TPT/Fastload/Fastexport) along with Unix and shell scripts
- Having good amount of experience in Analysis, design, Coding and Data validation cycles
- Design, Develop, Test ETL programs and scripts to acquire data from the source systems and loading in to enterprise data warehouse by writing transformation views
- Strong Hands on experience-Teradata SQL
- Ensure product quality and completeness of unit testing and documentation
- Ability to understand and document requirements
- Able to deploy and implement the codes according to the functional specifications in SIT/UAT and Production
- Experience with software configuration management and release processes
- Knowledge and understanding of data warehouse fundamentals and architecture
- Excellent written and verbal communication and presentation skills
- BS/MS EE/CS degree or equivalent
109
Lead Etl Developer Resume Examples & Samples
- Candidates must have hands on expertise designing high volume repeatable ETL processes for large enterprise software and developing very complex data transformations
- Candidate will be responsible for the design, development and support of secure and efficient ETL (Extraction, Transformation and Loading) components, which will be used to move large amounts of data from source data and software application data stores into the optimized operational databases
- Working with technical and/or business teams to extract and document data integration/exchange requirements
- Tuning the ETL processes
- Leading and/or participation in technical design sessions and development of related technical project artifacts (including technical and system documentation) necessary to support ETL processes including well tested, detailed deployment documentation
- Participation in development and execution of unit, system and user testing
- Completion of applications development by coordinating requirements, schedules, and activities
- Stakeholder management with different interfaces of ETL and Reporting
- Collaboration with teams (onsite and offsite)
- Troubleshoot development and production problems across multiple environments and operating platforms
110
ETL Developer Resume Examples & Samples
- Design and develop ETL jobs used to process the data from our clients
- Propose architectural improvements and implement overall systems designs for internally hosted platforms using ETL, Database, and Business Intelligence tools
- Write ad hoc SQL queries to troubleshoot and for unit testing the data loads
- Assist with database design and modeling used to manage our data as a resource
- Responsible for ensuring Continuous Delivery and Release Management of all components works smoothly in an automated fashion
- Responsible for design, maintenance, and monitoring of UNIX infrastructure for availability, stability, while providing good response time to our end users
- Provide support in monitoring, back-ups, reporting, problem identification and mitigation, and service improvements
- Keep up to date with the newest technologies by continuing research and learning
- Mentoring colleagues as new processes and tools are introduced and retired
- Experience with ETL tools such as Pentaho or Talend
- Experience with SQL and/or non-SQL databases as Postgres, MongoDB
- Experience with Reporting Tools as JasperSoft, Highcharts or Tableau
- Experience with Data Management best practices, including multiple data formats
- Experience with Agile software development, teams, CI/CD, delivery tools, and best practices
- Experience with UNIX OS distributions (Centos/SUSE/Redhat) and shell scripting (bash, ksh), Perl, Python, etc
- Experience with UNIX software installation processes, systems monitoring, daily operational activities, first level support, detection of issues, and abnormal systems behavior
- Ability to perform initial problem identification, categorization, and incident notification
- Desirable experience with OpenLDAP or Liferay operations
- Java Development experience is a plus
- Strong automation, problem-solving skills, and ability to follow through to completion
- Bachelor’s degree (or equivalent) in Computer Science, Information Systems
- 1-3 years of experience in ETL/BI domain highly desired
- Strong team-player
111
Lead Etl Developer Resume Examples & Samples
- 10+ years’ experience in a consulting or cloud development organization with at least 2 years’ experience in a SaaS environment
- Excellent skills in analyzing and debugging the capabilities of Kettle Community/Enterprise Edition
- Demonstrated ability to evaluate architectures and designs,
- Experience developing ETL for cloud solutions
- Must have skills : Kettle (3-4 years), Java, XML, SQL, and SVN
- Demonstrated ability to work on any two or more of the following technologies: JBoss / Tomcat, SQL Server / Oracle / DB2, RedHat Linux, Windows
- Demonstrated strong verbal and written communication skills
- Experience working in a self-directed, independent capacity
- Demonstrated ability to work collaboratively with different geographic and functional groups
112
Senior Big Data ETL Developer Resume Examples & Samples
- At least 7 years experience within a total information technology (IT) environment
- At least 5 years experience with design, development, automation, and support of applications to extract, transform, and load data
- Strong communication & problem management skill. Able to communicate clearly and concisely across different levels of management
- Any scripting language such as Python & R
- Application development tools
113
ETL Developer Resume Examples & Samples
- At least 2 years experience with Informatica PowerCenter
- Technical troubleshooting
- Unix/Linux shell scripting
114
ETL Developer Resume Examples & Samples
- Must have extensive experience in java server-side development including multi-threading programming and service-oriented architecture
- 3+ years of hands-on programming experience in design and coding of commercial application using Java
- Experience developing data access and APIs for distributed applications
- Experience with low-latency platforms
- Hands on experience with JDBC/ODBC
- Experienced with ORM technologies
- Good knowledge of XML/XSD, JSON and related technologies
- Have basic SQL and general knowledge of TCP/IP
- Experience with iterative SDLC such as Agile, SCRUM, Test-Driven Development
- Effective written and verbal communication skills required
- Proven ability to solve problems
- Must be highly motivated, to work independently or on a team and drive solutions with minimal supervision
- Ability to work productively in a globally distributed development team
115
Database / ETL Developer Resume Examples & Samples
- Analyzes and evaluates existing or proposed systems, and devises computer programs, systems and related procedures to process data
- Encodes, tests, debugs and installs the operating programs and procedures in coordination with computer operations and user departments
- May train junior level personnel in technical complexities of assigned work
- Reviews progress with management
116
ETL Developer Resume Examples & Samples
- Extensive hands-on experience with configuration of MDM platforms, including data model development, data steward UI configuration, source integrations, and export/target integrations
- Experience with API based transaction and bulk integrations with cloud based platforms
- Extensive background developing ETLs and integration of MDM platforms with data warehousing environments
- Deep understanding of MDM designs and implementation strategies
- Excellent communication verbal and written communication skills are a must
- Experience with Cloud Based MDM platforms that utilize API based integrations: Reltio, Informatica Cloud MDM/Data Scout, Talend
- Experience with API based transaction and bulk integrations utilizing Mulesoft
- Experience with ETL tools such as Microsoft SSIS/DTS, SAP Data Services, Informatica, Data Stage
- Experience with cloud based data cleansing / prep platforms such as Informatica Rev, Paxata Rev, etc
- Experience working with cloud based hosting platforms such as Microsoft Azure and/or Amazon AWS
117
ETL Developer Resume Examples & Samples
- Serve as development lead on Solution Design and Delivery team with healthcare measurement and engagement portfolio (HCME)
- Manage, mentor and develop onshore development resources and provide project related directions to offshore team
- Acting in a technical SME role, support development, QA, and production support teams in SDLC and operational activities
- 5+ years of experience in IT systems analysis, data analysis, software design, or a combination of roles within the SDLC lifecycle
- 3+ years of recent hands-on experience with ETL toolset in Unix/Linux environments involving data management (Data Stage or Talend preferred, but other ETL tools considered)
- 1+ years of Teradata experience (must have worked with Teradata within the last 1 year)
- 2+ years of experience writing and tuning the SQL queries and stored procedures with relational databases
- Excellent understanding on data warehousing concepts (ELT) and worked in an enterprise data warehouse environment with large volume of data processing
118
ETL Developer Resume Examples & Samples
- Typically 8-10 years of relevant work experience
- Clear understanding of IT infrastructure and its components
- Knowledge about varied ETL tools (Ab Initio, DataStage, Informatica, Talend) and other BI tools (Cognos, MicroStrategy, Tableau)
- Work with cross functional teams ( Support teams for platform, applications, Project Managers)
- Ready to take additional responsibilities
- Ability to acquire skills on own
- Coaching and mentoring for Level 1 and Level 2 engineers
- Independently generates solutions based on analytical, technical skills and business knowledge
- Ability to articulate and compare alternative approaches
119
ETL Developer Resume Examples & Samples
- Strong ETL background (SPSS, Informatica, Etc.)
- Extensive Linux/UNIX server experience (from a production support perspective)
- Data integration/data warehousing experience
120
Atlanta Data & Analytics ETL Developer Senior Consultant Resume Examples & Samples
- Strong project management and client relationship skills
- Prior management and direct supervisory experience in a team environment
- Self-starter and can operate independently as needed
- A high threshold for ambiguity and lack of structure and process during early phases of engagements
- Creative and logical problem-solving abilities
- Excellent leadership, interpersonal, and team building skills
- Mentoring and people development capabilities
- Advanced listening skills and written and verbal communications
- Ability to multi-task and maintain professional demeanor under pressure
- Organization and time management expertise
- Proficient in Microsoft Office suite applications with specific emphasis on Access, Excel, Visio and PowerPoint
- Prior experience working in either Data warehousing or Business Intelligence
- Experience with any major ETL vendor, such as SSIS, Informatica, Data Stage, etc
- Experience designing and implementing data models for applications or reporting
- 3+ years working with SQL including intermediate to advanced knowledge on DML / DDL
- Experience with any of the major Business Intelligence reporting tools, such as BusinessOjbects, Hyperion, Cognos, Microstrategy, Tableau, QlikView, or SSRS
- Experience working within a Microsoft SQL Server, MySQL, Oracle, TeraData, or other major database management systems
- Experience with either Master or Meta Data repositories
- Experience working with business stakeholders to translate business issues into technology solutions and vice versa
- Demonstrated knowledge of technology project risks and strategies for managing and mitigating them
- Data Governance is a plus
- Travel throughout the month frequently required based on client requests/commitments
121
ETL Developer Resume Examples & Samples
- Bachelor's degree from a 4 year college or university required
- US Citizen / Permanent resident (Sogeti does not sponsor any work visas)
- Data Stage is required
- 5+ years of deep experience as an ETL developer well-versed in ETL tool usage, architecture, design and development
- 2+ years working on projects with both onshore and offshore resources
- 5+ years working on BI/DW projects
122
EIM ETL Developer Resume Examples & Samples
- Participate in the development and support of an enterprise wide data transformation and movement architecture and platform
- Design, develop and test ETL applications consistent with application architecture guidelines
- Design error-processing routines
- Analyze business requirements as they relate to the ETL process, research, evaluate and recommend alternative solutions
- Transform business requirements into technical requirement documents
- Work productively in a team environment
- Communicate effectively with business and IT staff across functional departments
- Work with management and staff to establish best practice standards for ETL functions
- Lead development of new methodologies for supporting data transformations and processing in a corporate-wide ETL solution
- Provide after business hours support for production ETL systems
123
ETL Developer Resume Examples & Samples
- Ability to create high complexity detailed technical design specifications, Develops detailed analysis, design, construction and testing specifications ensuring technical compatibility and integration
- Ability to act as a developer responsible for the planning, completion and coordination of work activity for projects involving more than one developer. Ability to lead walk though of design documents and provide technical leadership over programming team
- Strong analytical and technical aptitude
- An understanding of a variety of modeling and/or diagramming techniques, with the ability to create process flow diagrams and the ability read data flow and entity relationship models
- Demonstrate collaborative skills working within a project team of diverse skills Bring strong communication skills including oral, written and presentation skills plus creativity, and problem solving skills to a challenging environment
- Provide guidance and direction to less-seasoned staff
- Coordinate with deployment and support resources to ensure the solutions gets implemented smoothly into QA and Production environments
- Take an active role in joint solution design and be an advocate for long term quality in the process
- Experience working with multiple file structures
- Experience with complex shell scripting using Unix
- Thorough understanding of technological infrastructure and how it relates to projects
- Financial Services / Banking Industry domain background
- 5 years of experience troubleshooting performance issues
124
ETL Developer Resume Examples & Samples
- Develop complex Talend ETL processes for integration between systems
- Design & Develop web Services in RESTful & SOAP
- Ability to break down business stories into smaller development components
- Ability to work in fast-pace, agile environment
- Gather business requirements and follow through to design and execution
- Work with other developers to implement requirements
- Responsible for software development including software, unit test plans, unit testing, QA support and post-release
- 5 years of IT experience with a Bachelor's Degree in computer related field or equivalent
- General application development (4+ years)
- Talend (1+ years preferred)
- 2+ years’ experience in developing ETL processes
- Experience in one or more of the following: Oracle / MSSQL / MySQL (2+ years)
- Java (Core, Servlets, JDBC, etc) (1+ years)
- Knowledge of integrating into Salesforce, Oracle, Unidata or BigCommerce an advantage
- Familiarity with integrating data from various sources (flat files, databases, web services)
- Data Modeling (2+ years)
- Experience utilizing and extending ETL solutions (e.g., Informatica, Talend, Pentaho, Ab Initio) in a complex, high-volume data environment
- Proven proficiency with development of high performance ETL to transform and load high volume of data
- Knowledge of Big Data technologies (e.g., Hadoop, BigQuery) is preferred
- Proficiency in the Microsoft Office Suite
- Excellent verbal and written communication skills, and ability to communicate with individuals at all levels of the organization
- Ability to prioritize and work with minimal supervision
- Strong leadership skills with a demonstrated ability to motivate and coordinate projects
- Ability to work in a flexible environment where requirements and procedures continuously evolve
125
ETL Developer Resume Examples & Samples
- Analyze customer requirements, design and implement Informatica mappings, sessions and workflows
- Perform data analysis and develop source to target mapping specifications
- Create and maintain ETL documentation
- Interface with project teams to perform rapid development using agile methodology
- Must possess a Bachelor's or higher degree in Engineering, Information Systems, or an equivalent degree program
- Must possess a minimum of 6 years of experience with Informatica PowerCenter or ETL software equivalent
- Must possess a minimum of 6 years of experience developing Data Warehouses
- Must possess experience with Oracle databases and strong SQL background
- Must possess excellent written, verbal and interpersonal communication skills
- Must be capable of a high level of accuracy and attention to detail
- Must possess these essential qualifications: (1) ability to quickly adapt to new situations, (2) strong commitment to a team environment, (3) willingness to learn new technologies, (4) ability to resolve and clarify requests/requirements, and (5) ability to establish, maintain and follow documented processes and procedures
- Must possess or be able to obtain a DHS/CBP Clearance
- Experience with CBP
- Experience with Atlassian toolset, including JIRA and Confluence
126
ETL Developer / Analyst Resume Examples & Samples
- 6 + years' of Informatica development experience with exposure to version 9.x. Should be at or near expert level with Informatica and possess a solid working knowledge of SQL and ETL load and extract processes within Informatica
- Expected to have hands-on experience in development of complex ETL mappings that include usage of SCDs and various transformations like Normalizer, XML Parser/Transformer, Joiner, Aggregate, Expression, Filter, Router, Lookup, Procedure, and Union etc
- Hands-on development experience in Unix Shell Scripting
- Should have specialization on root cause analysis for discrepancies occurring during reconciliation of reports
- Working experience on requirement gathering, preparation of technical specification documents, design and build of ETL. Should be well aware of SDLC for ETL project
- Knowledge of enterprise scheduling tool (like Control-M)
- Exposure to reporting tool (like Business Objects)
- Team player and self-driving with excellent verbal and written communication skills
- Self-sufficient, independent requiring very little supervision or intervention a must
127
Software Engineer / ETL Developer Resume Examples & Samples
- Design, build, test and maintain scalable and stable off the shelf application or custom built technology solutions to meet business needs
- Contribute to the entire implementation process for new applications and enhancements to existing applications
- Meet with business partners to understand business needs
- Contribute to overall solution design
- Responsible for build and test of applications
- Conduct root causes analysis and complex performance tuning
- Bachelors degree in Computer Science, MIS, related field or equivalent experience
- Experience in data development and ETL
- Understanding of data architecture
- Python, SWL, & ETL
- Web Services, e.g. RESTful/SOAP
- Relational data bases: Oracle, SQL Server, Teradata
- Experience with call center systems
- Knowledge of data warehousing and data modeling strategies
- Knowledge of Agile development strategies
128
Lead Etl Developer Resume Examples & Samples
- Act as a role model to demonstrate the company's core values of respect, honesty, integrity, diversity, inclusion, and the safety of others
- Support and maintain applications using the required tools and technologies
- Provide support for applications, including involvement with the support center, network operations center (NOC), infrastructure teams, and vendors as appropriate
- Assist other personnel on assignments, including mentoring or providing on-the-job training to more junior associates
- Lead and participate in the design and implementation of large and/or architecturally significant applications
- Champion company standards and best practices
- Work to continuously improve software delivery processes and practices
129
ETL Developer Resume Examples & Samples
- 2+ years’ experience working on systems integration, data integration and/or database design
- Experience with ETL tools, ideally experience developing in Pentaho Kettle (SSIS or Alteryx a plus)
- Strong understanding of the SQL language
- Experience with Linux / UNIX operating systems
- Program management experience-from requirements gathering through implementation
- Experience with columnar store databases (such as Vertica) and working in a massively, parallel processing (MPP) environment a plus
- Experience with Shell scripting a plus
- Experience with Customer Relationship Management (CRM) applications, Campaign Management applications, and / or Database Marketing are a plus
- Experience writing Java, J2EE, Java Applets, Object-Oriented Design (OOD), Web Programming (HTML/CSS/Java Script), Servlet/JSP development a plus
- Ability to manage conflicting priorities and deadlines
- Strong communication and client interaction skills
- BS degree (Computer Science, Engineering, Information Systems preferred)
130
Ab Initio Etl Developer Resume Examples & Samples
- A Minimum of 5 years development work with Ab Initio ETL
- Strong experience with UNIX/Linux
- Strong experience with Oracle PL/SQL
- Experience Bash and/or Korn Shell Scripting
- Experience with JAVA J2EE
- Experience with TIBCO BW
- Experience with Autosys
- Good understanding of Perl
- Good knowledge of GAAP Accounting and General Ledger process is a plus
- Excellent communication skill is preferred
131
Doh-ssis ETL Developer / TS Resume Examples & Samples
- 5-7 years of experience as an SSIS ETL developer
- Data profiling and data modeling experience
- Strong in data warehousing concepts and techniques
- Experience creating custom reporting tables using SQL (such as fact, dimension, aggregate, slowly-changing dimension)
- Snowflake and Star Schema design
- Effective verbal and written communications skills and effective presentation skills
- Self-motivator, independent, cooperative, flexible, creative
- Strong OLAP/cube/analytical data model design expertise
- Cognos experience
- 25% of Total Work Effort: Requires 5-7 years' experience as an SSIS ETL Developer working in Microsoft SQL Server
- 25% of Total Work Effort: Knowledge of administration of SQL Server for transactional and analysis systems
- 25% of Total Work Effort: Strong cube/analytical data model design expertise (preferred)
- 25% of Total Work Effort: Snowflake and Star Schema design
- Designs, develops and monitors Enterprise Transformation Language (ETL) processes using SSIS
- Performs data profiling, ETL development and administration, and release management
- Data modeling using modeling tools and methodologies
- Gathering, documenting, and designing data requirements
- Creates and maintains the logical and physical data models for the production and Business Intelligence Data Warehouse and Data Marts
- Develops prototype views and works with business users both internal and external to refine their requirements
- Demonstrates self-reliance in researching technical solutions and product functionality
132
ETL Developer Resume Examples & Samples
- Understanding of ETL concept and solutions
- DataStage or equivalent
- DB2 on z/OS
133
ETL Developer Resume Examples & Samples
- As an Applications Developer, you will provide high quality technology solutions that address business needs by developing applications within mature technology environments
- Participate in code reviews and ensure that all solutions are aligned to predefined architectural specifications; identify/troubleshoot application code-related issues; and review and provide feedback to the final user documentation
- 5 + years experience in Ab-Initio coding of medium to large scale ETL applications
- Experience using Ab-Initio GDE, BRE, Continuous Flow and EME required
- Experience in UNIX operating environment is required
- Experience in Java/J2EE development a plus
- Mainframe experience is a plus
- Exposure to DB2 is a plus
- Ability to communicate at all levels of management and with customers
- Demonstrated skills both written and oral are required
- Financial industry experience and credit card or payment systems experience in large scale/high volume industry is preferred
- Good business knowledge of end to end Credit Card Authorizations processing preferred
134
Software Engineer / ETL Developer Resume Examples & Samples
- Healthcare Experience Preferred
- Informatica or similar ETL tools required
- Teradata or other relational database systems preferred
- Unix Experience Preferred
135
ETL Developer Resume Examples & Samples
- Researches and evaluates alternative solutions and recommends the most efficient and cost effective application programming solution
- The ETL candidate needs to have experience
- Developing ETL jobs in IBM InfoSphere DataStage / QualityStage version 8.5 or 8.7
- Experience with importing various data sources (flat files or Database tables), editing and transforming the data to be loaded into a Database stage
- Experience with Netezza data environments
- Healthcare experience 3 to 5 years
- Good communication skills and be able to be a technical team lead for the ETL developers
- Familiar with general ETL "leading coding practices” and common coding standards. The candidate should also demonstrate good written skills to be able to write technical documentation
- Minimum of 5 years progressive experience in a large-scale development environment including all phases of a system development lifecycle (SDLC) with minimum of 3 years leadership/supervisory experience
- Extensive experience in data analysis and/or reporting along with strong knowledge of database and related technologies (SQL, OLAP, etc.)
136
ETL Developer Senior Resume Examples & Samples
- Analyze reporting requirements to determine development methods and development templates
- Determine the job scheduling
- Develop ETL jobs that satisfy identified model
- Create and run tests on all solutions while optimizing ETL processes
- Document all ETL processes
- Support other ETL Developers in development and troubleshooting data issues. Monitor nightly loads and troubleshoot any issues that arise
- Participate in the development of best practices in ETL development for Georgia Tech
- Education:Bachelor's Degree or an equivalent combination of education and experience
- Work Experience:Four to five years of job related experience
- Certifications:N/A
- Skills: Experience in Design, Development & Build activities. Ability to maintain technical support documentation. Experience in Project life cycle activities on data warehousing or business intelligence development and maintenance projects. Knowledge of data extractions techniques. Understanding of Linux or UNIX operating systems, file systems, shell scripting. Understanding of Oracle and/or SQL Server, data marts, database management systems and data warehouses. Knowledge of full life-cycle experience on large/complex enterprise projects. Proficiency with automated data modeling tools, business intelligence and performance management software, MS Excel. Problem solving and analytical skills. Good written and verbal skills
137
ETL Developer Resume Examples & Samples
- Gather requirements from Business and IT teams, Identify source and target systems, Map and transform the data based on requirements
- Design SAP Data Services job flows to extract data from SAP and non-SAP systems, fine-tune jobs as necessary and schedule jobs using built-in or 3rd party schedulers
- Create and manage metadata objects
- Manage the assigned subject area in SAP BW and a SQL Server based Enterprise Data Warehouse and serve as the Point of Contact for any data needs
- Work with onsite and offshore consultants as needed
- Work closely with other team members and ensure standards are followed
- Monitor, communicate and troubleshoot issues with data integrity, data design, and technical software issues
- Effectively communicate status to IT and Business teams
- Data modeling experience in SAP HANA with some experience in tools like ERWIN or Power Designer
- Basic knowledge of Business Objects reporting tools like Web Intelligence, Lumira etc
- Some experience in Microsoft SQL Server Integration Services
- Experience with SAP BPC
- Experience in setting up a new SAP Data Services environment
138
ETL Developer Resume Examples & Samples
- 6+ years of experience with PostgreSQL
- 6+ years of experience with Informatica Power Center and SQL
- 4+ years of experience in the development, maintenance, and enhancement of Informatica Mappings, work-flows, and processes
- Experience with ETL development and processes from diverse data sources
- Experience with Informatica Power Exchange and Control-M at an advanced level
- Experience with data modeling concepts
- Experience with Data Warehouse, Oracle, Linux, and AIX
- Knowledge of IRS business systems and data
- Experience with the IRS
139
ETL Developer Resume Examples & Samples
- Designs, develops, codes, tests and debugs highly complex new software products or makes significant enhancements to existing software
- Factors emerging technologies and product supportability into design and implementation
- ETL Experience- particularly the TRANSFORM aspect of data
- General familiarity populating/loading data into databases
- Scripting language experience, as well as, string manipulation experience
- User-level knowledge of Pentaho, or similar ETL tools such as INFORMATICA, is preferred
- Experience mapping datasets to a predetermined model
- Familiarity with various databases (Oracle and Netezza) and associated utilities (such as SQL Loader, SQL Developer and SQuirreL)
- User-level understanding of JIRA is helpful
140
ETL Developer Resume Examples & Samples
- ETL tool Ab Initio experience required
- Experience utilizing SQL to create, load, and modify intermediate and data mart tables
- Experience with Unix shell scripting to create and execute SQL scripts
- Experience with a list processing tool (i.e. Group1 ,etc.)
- Strong knowledge of SQL, SAS and Microsoft Excel (pivot tables) for auditing and generating reports
141
ETL Developer Resume Examples & Samples
- Open minded to take on different roles ( other than the primary skill set) and work on other technologies as needed
- Participate in functional and design reviews , identify efficiencies and provides alternatives
- Participate in Test Strategy definition and creation of test scenarios/cases for DEV(Unit Test) /SIT/UAT and execution of the same
- Works with other team members, including DBA's, Other ETL developers, Technical Architects, QA , Business Analysts & Project Managers
- 3-5 years of hands on work experience in Ab Initio (Application development)
- 3-5 years of hands on work experience in Oracle (SQL and Stored procedures)
- Good understanding of UNIX systems and shell scripts
- At least 5 years of software development experience required in Operational Data Store / Data Warehouse environment
- Must have full life-cycle experience in ETL projects, preferably in the finance industry
- Strong partnership skills to ensure the effective management of all stakeholders involved
- Experience of testing methodologies including test strategy, test plan and script creation and execution
- Defect management experience
- Hands on experience with the ALM and QTP
- Flexibility to work on different projects and support both manual and automation testing
142
Teradata ETL Developer Resume Examples & Samples
- Translate business, and functional requirements into documented technical and architectural specifications
- Utilize development skills to build (code) and unit test new or existing systems functionality per technical specifications, with deliverables to include code builds and documented unit test results
- Develop application support documentation as required by the application support teams for acceptance of systems changes into production
- Build and unit test production deployment packages and implementation plans for scheduled systems enhancements
- Utilize planning skills to oversee development deliverables as required to implement new systems capabilities
- Facilitate/lead reviews (walkthroughs) of technical specifications and program code with other members of the technical team, communicating design, requirements, feature set, functionality and limitations of systems/applications to team and development lead
- Contribute to and work to meet project schedules by providing accurate estimates of effort required for development deliverables by providing updates on project progress to development and project management and by escalating issues which may affect project success
- 7+ experience working with Teradata systems as developer
- 3+ experience working with ETL tools like Informatica
- 6+ experience working with UNIX & Unix Scripting
- 5+ experience designing and implementing complex applications
- 6+ strong SQL and analytical skills
143
ETL Developer Resume Examples & Samples
- Build partnerships across the application, business, and infrastructure teams
- Develop programming specifications
- Design, code, and unit-test application code using SDLC best practices
- Complete estimates and work plans with the assistance of more senior team members as appropriate for design, development, implementation, and rollout tasks
- Communicate with the appropriate teams to ensure that assignments are managed properly and that completed assignments are of the highest quality
- Support and maintain applications using required tools and technologies
- Provide support for applications, including involvement with the Support Center, NOC, Infrastructure teams, and vendors as appropriate
- Provide off-hours support (24/7) as required
- Participate in the application technical design process
- Communicate timely status, including any potential risks/issues, to the appropriate teams to ensure that assignment releases are managed appropriately and that completed assignments are of the highest quality
- Potentially assist other personnel on assignments, including mentoring or providing on-the-job training to more junior associates
- Strive to continuously improve the software delivery processes and practices
- Bachelor's degree in information systems or related equivalent work experience in an information systems position
144
FCC ETL Developer Resume Examples & Samples
- Candidates must have experience in Ab-Initio(say 5+ years on Ab-Initio)
- Candidates can have preliminary Ab Initio experience but should have experience in any other ETL tool
- Strong knowledge in Extraction, Transformation and Loading (ETL) methodology
- Ab Initio (GDE, EME, Co>Op) knowledge or equivalent technology like TalenD
- Good working Knowledge of Database (Sybase and/or Oracle) and other ETL tools like TalenD would be a plus
- Strong Test Driven Development experience
- Strong in UNIX Shell Scripting
- Strong SDLC capability for medium to large projects
- Experience of Futures/OTCC or Capital Markets back office flows in general desirable
- Practical experience in analysis/design/implementation of successful projects in the Futures back/middle office area desirable
- Strong oral/written communication skills and ability to facilitate discussions
- Flexible communication style of multi-geography stakeholder groups
- Quickly grasp/master new requirements and related knowledge
- Manage tight deadlines or unexpected requirement changes
- Ability to learn/understand technical implications of system design
- Team player in solid/matrix reporting organisations
- Willingness to ask questions, challenge the process and seek out answers
- Ability to work independently, multi-task, take ownership and drive strategy
- Educated to degree standard preferable
- Exceptional candidates who do not meet these criteria may be considered for the role provided they have the necessary skills and experience
145
Analytics ETL Developer Resume Examples & Samples
- 4+ years ETL development using SQL Server and SSIS
- Experience planning and designing data mart/EDW/EIM projects
- Thorough understanding of typical DB design practices, ETL development including
- Proficiency in: R, Python, and/or JavaScript
- Alteryx or Talend a significant plus
- Strong knowledge of quality assurance methods and best practices
- Experience with a visualization platform (Tableau, PowerBI)
- Working knowledge of AWS/Azure, NoSQL, Oracle, SAP HANA platforms
146
Oracle ETL Developer Resume Examples & Samples
- Manage the full lifecycle of the Problem Management process
- Proactively identify problem trends and known error conditions and work towards a permanent solution
- Perform trend analysis based on statistical data provided by Problem Analysts, the Incident Management Team or PM Tools
- Work with design/architecture teams to ensure best practices are adopted to ensure stability and supportability of applications and infrastructure
- Responsible to provide problem resolution and document
- Ability to coordinate with multiple teams to source appropriate skills for effective problem resolution
- 5-7 years’ experience in ETL (Informatica is preferred), Oracle and related technologies
- 3+ years’ of experience in Relational database concepts, Data analysis and SQL
- 3+ years’ of robust Knowledge and implementation experience of Informatica is required
- Experienced in working with Unix and Ctrl-M jobs
- Knowledge of Optimization of the ETL and Oracle Pl/SQL is a plus
- Ability to work in agile kind of environment
- Understanding of Collateral business domain is a value add
- Understanding of capital markets and investment banking regulations is a value add
147
ETL Developer Resume Examples & Samples
- Bachelor or graduate degree in computer science (or related field) plus a minimum of 7 years experience in a Data Warehouse environment
- Dimensional Modeling experience
- Expert knowledge of various ETL tools like Informatica, Cognos, Hammerstone
- Structured Query Language (SQL)
- 5+ years experience working with relational databases
148
Etl Developer Data Management Resume Examples & Samples
- Create and enhance existing ETL/models/ Loads using Talend
- Partner with architecture team and optimize existing Talend Jobs
- Develop Sources of Truth models and expose the same for the consumable layer of the data lake
- Prepare required documents to migrate code in production
- Minimum 4 years of overall IT experience in Business Intelligence, data warehousing or data ingestation
- 3 yrs. experience in Developing/designing data models using Talend
- Minimum 1 yr. experience in developing solutions using databases like Greenplum, or Postgress
- Ability to take ownership of tasks and deliver without supervision while using their discretion to seek help when necessary
- Strong team player that collaborates well with others to solve problems and has experience working within a global environment
- Should have good communication skills and should be able to bridge the communication gap between business users and the technical team
149
ETL Developer Resume Examples & Samples
- 8+ years technology experience
- 5+ years Oracle PL/SQL and Sybase Transact SQL
- 2+ years Scrum team member experience
- 2+ years Unix scripting
- Securities industry experience, especially compliance domain knowledge
- Distributed teamwork experience
150
SQL / ETL Developer Resume Examples & Samples
- Works directly with users in defining new application requirements and resolving project issues
- Analyzes a chain of events and applies technical knowledge following established procedures and/or detailed specifications
- Troubleshoots most applications problems independently
- Tests, implements, documents and maintains system components based on specifications
- Writes basic documentation of a new or proposed system
- Translate business requirements into specific ETL process designs
- Provide expert advice, counsel and technical expertise to the project team to help assure that ETL solutions are designed and developed in the optimal manner and in accordance with industry best practices
- Create and maintain Technical Design document (Logic Flow Diagrams), Mappings and Production Support & Administration document
- Deploy ETL solutions to production and provide support for operations and problem resolution
- 4+ years of experience using and developing complex SQL scripts to manipulate large data structures
- Experience in Data Modeling skills especially have solid experience working with dimensional modeling in support of large environments
- Experience building reusable ETL components
- Design and architecture background is a plus to assist in providing data integration solutions using best practices
- Experience in trouble shooting technical issues, and mentoring team members is a strong component to the team environment
- Strong preference for healthcare experience, general healthcare experience or experience with clinical data sets
151
ETL Developer Resume Examples & Samples
- Strong knowledge of relational database design. Working knowledge of any one of these domains – Teradata, Vertica , DB2 – preferred
- Strong experience in ETL Tools - IIS Data stage is required
- Extensive hands on experience in UNIX shell scripting, complex SQL queries and with performance tuning queries
- Must be a team player in a fast paced environment with competing priorities and deadlines
- Knowledge in Java, MQ, Rule based engines is a plus
- Experience working with regulated financial organizations is a nice to have
152
ETL Developer Resume Examples & Samples
- Minimum one (1) year of software development and configuration experience required
- Demonstrated working knowledge of ETL, PL/SQL and Oracle database technologies
- Familiar with a variety of the field's concepts, practices, and procedures, and relies on experience and judgment to plan and accomplish goals
153
Lead Etl Developer Resume Examples & Samples
- Perform and oversee development, quality assurance reviews, documentation, system deployment, training, and project setup/support for the Enterprise Data Warehouse and ETL processes
- Lead the Build, Test, and Implementation phases of assigned projects, with a diverse development team spread across multiple locations and time zones
- Performing project setups, analyzes, designs data integration solutions. Responsibilities also include selection, acquisition, installation and configuration of applications licensed from third parties, and interaction with vendors is required
- Investigate production ETL issues and work to determine the root cause of problems
- Prepare detailed development cost estimates
- Conceptual schema: Understand and design of the Conceptual schema including the semantics of a domain being the scope of the model its entity classes, and relationships assertions about associations between pairs of entity classes
- Physical Database: Physical Database design which includes: includes detailed specification of data elements, data types, indexing options and other parameters residing in the DBMS data dictionary
- Build specifications for extract, transform, and load processes, following standards for Informatica to facilitate the data mart/warehouse fact and dimension models as well as system integration
- Work with business to design specific subset of warehouse data for producing analytical data stores. Understanding elements of the data warehouse and facilitating the build of a warehouse to produce data marts that meet the business requirements
- Ensure warehouse and database functions are in accordance with Data Governance policies as set forth by KBR policies and standards
- Maintain proper metadata tools in order to perform proper usage and impact analysis
- Perform data queries for analysis by understanding existing warehouse structures and being able to answer user questions regarding the data
- Ensure consistency with existing databases and warehouses, enforcement of standards and consistent processes
- Define and recommend BI and integration standards, processes and technologies
- Research and recommend software technology direction
- Supervision and mentoring of staff; allocating and monitoring work
- A minimum of 7 years of experience working with enterprise data warehouse projects
- A minimum of 7 years of experience with Informatica PowerCenter
- Experience with installation and configuration of Informatica PowerCenter
- Experience with SQL Tools such as Toad/SQL Navigator
- Extensive experience working with Oracle and Microsoft SQL Server databases
- SQL query and performance tuning
- Excellent organizational, oral, written, and presentational communication skills in order to work with all levels of staff and management
- Extensive experience deploying and supporting large, complex data warehouse/business intelligence solutions
- Experience with data modeling tools such as Embarcadero or Erwin. Embarcadero experience is preferred
- Experience with Scheduling tools
- Experience with project planning and management, including making operational decisions, monitoring progress, taking corrective action, and communicating results
- Candidate must have a strong customer service orientation
154
ETL Developer Resume Examples & Samples
- Design, code, test, debug, document and support all types of applications consistent with established specifications and business requirements to deliver business value
- Lead complex projects to achieve key business objectives
- Collaborate with the team on application architecture design and decision-making
- Develop innovative solutions to meet the needs of the business
- Provide alternate design solutions along with project estimates
- Design and implement application enhancements in collaboration with different teams
- Troubleshoot production support issues post release deployment and come up with solutions. Ability to solve complex production issues
- Predict emerging customer needs and develops innovative solutions to meet them
- Will be expected to function as a mentor for junior developers, providing assistance where needed
- Will be expected to handle smaller projects completely on their own, including interactions with other teams and 3rd parties for design and architecture
- Involvement with senior management in terms of supplying input for key design and architecture decisions, as well as work estimation and resource planning
- 5+ years ETL experience
- 5+ years relational database experience
- 3+ years SQL Server experience
- ASP.Net and C#.Net experience
- Healthcare Industry experience
155
ETL Developer Resume Examples & Samples
- Design and build ETL solutions against RBMS and also dimensional databases to address business requirements
- Partner with other technical teams and in defining data mapping rules, data load procedures in accordance with data governance policies and controls
- Plan and model data integration processes and to build data models supporting complex transformation
- Assist business and technology stakeholders in establishing data management framework with necessary data quality controls and governance
- Troubleshoot data integration issues in a timely manner, in collaboration with DBAs, system administrators and other technology teams
- Drive solution delivery by closely working with business users, PMO, infrastructure and other technology teams in all phases of SDLC (Agile and Waterfall)
- Work with management in building the project/technology roadmaps, project scoping and analysis
- Develop functional and technical specifications
- Lead/mentor offshore technical developers and review deliverables for accuracy, quality, application performance and completeness
- Strive for top quality results and continuously look for ways to improve and enhance Enterprise Applications functionality, reliability and performance
- 5 + years of experience in designing and building ETL solutions against RBMS (Oracle, MySQL, SQL Server) and also dimensional databases (Hyperion Essbase), including job scheduling, exception handling & data reconciliation
- 4+ years of hands-on experience with IBM InfoSphere Data Stage (at least 6 months on 11.5)
- 4+ years of experience with writing SQL queries, DB views and stored procedures
- Strong knowledge of database systems principles/design, data construction and integration of applications systems
- Good understanding IBM Metadata Asset Manager
- Exposure to other industry standard ETL solutions (ODI, Pentaho and/or Informatica)
- Excellent customer service orientation, business communication skills and ability to deliver results under tight timelines
- PREFERRED EXPERIENCE
- Exposure to Hadoop
- Experience with one or more of the reporting platforms (Oracle Hyperion , OBIEE or Business Objects)
- Prior experience in a financial services company, supporting Finance / Accounting /Balance Sheet Management /Risk applications
156
ETL Developer Resume Examples & Samples
- Work on design and development of large volume data processing applications/operational stores in iterative/agile development model
- Work with Data Analysis teams to verify requirements, and Source to Target mappings
- Prepare design/solution analysis based on requirements from internal and external sources to evaluate and demonstrate program effectiveness and efficiency, and problem solving
- Develop scalable reporting processes in collaboration with larger development team
- Research complex functional data/analytical issues
- Implement appropriate checks for data integrity, data quality as part of development effort
- Make recommendations and communicate status to leadership as needed
- Deliver high quality results in a fast changing and high growth business environment
- Utilize Talend for ETL within a Hadoop/Big Data environment
- 5 or more years of ETL development experience (SSIS, Informatica, DataStage, Talend, etc.)
- 5 or more years of RDBMS development experience
- 3 or more years’ experience designing and implementing effective data strategies in enterprise level data stores, data marts or data warehouses
- Experience with Talend
- Data modeling and data architecture experience
- Experience working in Big Data/Hadoop environment
- Healthcare industry/claims experience
- Experience developing innovative approaches
157
ETL Developer Resume Examples & Samples
- Works with external vendors and internal business and technology staff to accurately gather and interpret requirements, specifications, and database models
- Designs, develops, tests, implements, and supports innovative and optimal data solutions
- Works with the Data Architects, DBAs and Business Intelligence team to design, implement, and support end-to-end data solutions across multiple platforms, environments, domains, and locations
- Minimum three years experience designing, developing, testing, and implementing ETL solutions using enterprise ETL tools (experience with SSIS is preferred)
- Minimum two years experience developing and implementing data integration and DW solutions in a SQL Server database environment (experience with Netezza, DB2, and an Oracle 11g/12g is a plus)
- Expert SQL development skills are required (T SQL is required)
- Proficient in converting flat file, XML, and fixed length formats
- Understanding of SQL Server RDBMS
158
ETL Developer Resume Examples & Samples
- Serve on the Systems Integration Solutions team, which provides data feeds to many applications and third-party vendors and uses Ab Initio, Informatica, AIX/UNIX, UNIX shell scripting, Tivoli Workload Scheduler, Connect:Direct, SQL scripting and stored procedures, DB2, and Oracle
- Lead and participate in the design and implementation of large or architecturally significant applications
- Support and maintain applications using required tools and technologies, which will include working with the Support Center, the Network Operations Center, infrastructure teams, and vendors
- Provide off-hours 24/7 support as required
- Communicate with the appropriate teams to ensure that assignments are delivered with the highest quality and in accordance to standards
- Bachelor’s degree in information systems or related equivalent work experience in an information systems position
- Experience working with and planning projects of medium size or complexity
159
ETL Developer Resume Examples & Samples
- 1-2 years development experience with Hive, Spark & Python
- Java- at least 3 years of Java development experience
- Batch Processing for data extraction and analysis
- Pythons and Shell Scripting experience (1 - 5 years). This expertise will help create the batch processes
- 1-2 years Hadoop experience
160
Database / ETL Developer Resume Examples & Samples
- Provide operational analytics to support better management of MIS
- Extracting production related information from various databases and formulating analytics to import to Data warehouses
- Providing routine process/operational control reports and/or Controls Dashboard support
- Develop appropriate metrics and associated reporting to support test/control analysis on new processes or procedures
- Provide analytics support/justification for project business cases
- Provide process improvement analysis using process modeling and simulation techniques to understand the impact of process changes
- Attend technology design meetings and recommend security and data improvements – and will be empowered to work on those prioritized changes
- Identify and troubleshoot code-related issues associated with security and performance – then get to design and build solutions to these issues
- Follow best practices around code maintenance and deployment strategies
- Incorporate security requirements
- Code, test, modify, debug, document, and implement ETL and SQL
- Develop scripts to automate the execution of ETL using shell scripts under Unix environment
- Adhere to IT Control Policies throughout design, development and testing and incorporate Corporate Architectural Standards into application design specifications
- Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications; identify/troubleshoot issues; and review and provide feedback to the final user documentation
- Manage multiple priorities and projects coupled with the flexibility to quickly adapt to ever-evolving business needs
- An ideal candidate will have a bachelor degree in data analysis, operations research, computer science, mathematics, statistics or any other engineering with 5+ years for work experience
- Bachelor's degree in Computer Science, Business, or related field with minimum 5+ years of Database Development work experience
- 5+ years of database development and design experience in Oracle/MSSQL database platform
- 5+ years of experience in PL/SQL, Perl, UNIX, and Java
- 4+ years of experience in ETL tool Informatica and/or Pentaho
- Experience using modeling tools such as ERWin a plus
- Experience in designing database models including star, snow-flake schema, and cubing technology
- Experience in designing database feeds from various systems
- Experience of Java, .NET and QlikView is huge plus
- Must have work related experience in data modeling, analytics and reporting
- Must have experience in SQL using various tools such as Toad, SQL Developer etc
- Must be able to collate from various data sources (data warehouses, different database environments) and analyze large amounts of data and summaries findings
- Must have proven ability to work with large-scale/complex issues and work effectively across functional and organizational lines
- Ability to translate business requirements into technical requirements documentation
- Experience with full development lifecycle from inception through implementation
- Experience in Data Warehousing environment
- Knowledge of big data technologies like Hadoop/HDFS/Hive/Hbase/Impala & ETL tool integration experience with Hadoop file system a plus
- Eagerness to learn new technologies
161
Talend ETL Developer Resume Examples & Samples
- 2+ years of Data Integration experience with Talend Data platform
- Experience with both data integration and data quality Talend products (enterprise edition)
- Experience using Talend against both on premise databases such as Oracle, Microsoft SQL Server, DB2, MySQL as well as cloud platforms preferably AWS
- SQL programming skills
- ETL parallelization and performance tuning
162
ETL Developer Resume Examples & Samples
- Applies developed subject matter knowledge to solve common and complex business issues within established guidelines and recommends appropriate alternatives
- Works on problems of diverse complexity and scope
- Acts as a team or project leader providing direction to team activities and facilitates information validation and team decision making process
- Exercises independent judgment within generally defined policies and practices to identify and select a solution
- Ability to handle most unique situations
- May seek advice in order to make decisions on complex business issues
- Participates as the lead of a development team; may architect changes for others
- Completes code and reviews code of others, to implement solutions
- Typically a technical Bachelor's degree or equivalent experience and a minimum of 6 years of related experience or a Master's degree and a minimum of four years of experience
- 6 or more years of experience writing code (such as, and not limited to, C, PL/SQL, Unix Shell scripting; databases like Oracle/SQLServer; and Testing tools
- Advance understanding of modern software design and development methodologies
- Advance understanding of modern SCM (software configuration management)
- Advance understanding of testing tools and unit test scripting, and testing methodologies
- An understand of performing ETL without the use of ETL tools
- An understanding of Oracle Database Administration
- Familiarity with the UNIX operating system
- Understanding of quality and security standards
163
Teradata ETL Developer Resume Examples & Samples
- Team lead for large teams or managing one customer with multiple projects
- Responsible for estimation, planning and execution – with specific focus on requirement analysis and design
- Good awareness on DW architecture and design using Teradata
- Awareness of Teradata bteq, mload, fastload, tpump etc
- Performance tuning experience in Teradata
- Coordinate with customer, vendor and onsite/offshore folks
- DW architecture and design using Teradata
164
Lead Etl Developer Resume Examples & Samples
- Lead ETL developer utilizing SSIS / SSMS to load client and operational data into SQL Server or other ERA reporting repositories
- Best practice ETL design / recommendations to guide data management processes and executions
- Execution and management of ETL services for key initiatives
- ETL process management including documentation, source control, security and maintenance
- 5+ year’s experience in data systems management
- 3+ years ETL software and process experience
- 3+ years Strong understanding of SQL
- Familiarity with multiple database platforms
- Intermediate level of proficiency with MS Office platform
- Intermediate understanding of Business Intelligence software tools (Tableau and / or SSRS / etc.)
- Project / program management experience
- 3+ years of experience working with healthcare data
- Positions in this function include those responsible for assessment, design, management and programming ETL and data management projects
- Provides process analysis utilized for decision making involving complex ETL process management
- May make recommendations based on the analysis, and enable reporting capabilities as needed
- 4+ years of experience performing significant data design/ analysis and/or development
- Intermediate level of programming knowledge and relational databases, database structures and design, systems design, data management, data warehouse
165
ETL Developer Resume Examples & Samples
- Define data integration process and collaborate with Business analyst for various project needs
- Develop, test, and integrate code for existing data warehouse development in compliance with firm wide data management principles and security controls
- Develop and maintain controls on data quality and process
- Make recommendations, based on data profiling and data analysis, for changes to existing systems
- Document data integration strategies for data flows between disparate source/target systems for data warehouse
- Support production processes in NY and London
- Minimum 5 - 7 years strong hands-on development experience in SQL Server 2012/2014 Integration Service (SSIS) development, scripting development, error checking, performance tuning, job scheduling, and deployment methodology
- Minimum 5-7 years of experience in SQL Server 2012/2014 database development such as SQL, XML, function, procedure, indexes, table partition, and query optimization
- Minimum 5-7 years of experience in large complex 1TB + data warehouse environment and strong knowledge in ETL and data warehouse methodology
- Experience in Erwin Data Modeler
- Experience in scheduling tool such as Autosys
- Experience in C#, ASP.net, Java script is a plus
- Experience in SSRS and understand Microsoft full BI stack is a plus
- Experience in cloud technology such as AWS EC2, S3, RDS is a plus
- Experience in SQL Server Data Quality and Profiling is a plus
- Understanding of the project development life cycle
- Understand modern data warehouse design
- Advanced skills and experience with data modeling and enterprise data marts
166
SQL / ETL Developer Resume Examples & Samples
- 3+ years' experience working with SQL Server or supporting other database technologies (e.g. Oracle)
- 3+ years of experience writing reports using Microsoft SQL Server Reporting Services (SSRS 2005, 2008 or later version
- 3 years with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) is required
167
Database / ETL Developer Resume Examples & Samples
- Responsible for (1) development and maintenance of database systems to extract, cleanse, transform, load and maintain data; and (2) data migration * Five - ten years Informatica ETL developer experience * Strong, demonstrated analysis and problem solving skills * Strong planning and organizational skills * Strong written and oral communication skills * Demonstrated track record of strong UI development capabilities
- Proven working knowledge of ETL
- Strong analysis and design skills, including requirements analysis, Object Oriented design patterns, and UML
- Experience in Financial Services, preferably Wealth Management Social skills, persistence and backbone to work with difficult stakeholders
168
Lead Etl Developer Resume Examples & Samples
- Manage the successful delivery of development projects across the full application lifecycle
- Define project delivery phases, activities and milestones
- Create solutions to complex problems
- Provide frequent and effective progress updates to project stakeholders
- Cooperate closely with other teams to ensure proper alignment and coordination across application landscape as decisions often impact the team in which they reside and occasionally impact other teams
- Minimum 3 years of experience with design and implementation of data warehouses, management information systems, operational data stores including relational and multi-dimensional data modelling; and esign and implementation of ETL processes
- Solid knowledge of one or more of the leading RDBMS platforms (e.g.. Oracle, Teradata, DB2, MS SQL Server)
- Extensive knowledge of one or more leading ETL tools (e.g. Informatica PowerCenter, IBM Data Stage, Oracle Data Integrator, SAS Data Integration Studio, Business Objects Data Integrator, Microsoft SQL Server Integration Services)
- Strong problem-solving skills combined with the ability to creatively untangle complex issues and develop innovative and efficient solutions within a narrow time frame
- Some management skills would be nice to have
- Ability to easily communicate in English
169
ETL Developer Resume Examples & Samples
- Support of 9 out of 10 technology mergers in Poland
- Facilitation of 80% of mobile calls in Poland by systems implemented by Accenture
- Most complex IT transformations in Poland
- 60% of current accounts in Polish banks work on systems implemented by Accenture
- Design and implement medium and large scale Data Warehouses, Management Information Systems, analytical repositories (CRM, subject oriented Data Marts) and operational data stores
- Design logical and physical data models for normalized and multidimensional repositories
- ETL processes performance assessment, recommend improvements and fine tuning
- Maintain and support of the Data Warehouse systems operating in production environment
- Design and implement tools, processes and methods supporting Data Quality monitoring and management
- Plan, prepare and execute automated and manual tests of ETL processes
- Minimum 1 year of experience with design and implementation of Decision Supporting Systems (Data Warehouse, Management Information System, subject oriented Data Marts) in ETL and data modeling areas
- Solid knowledge related to ETL processes and architectures (e.g. operations metadata, data cleaning and conforming, slowly changing dimensions, data lineage, etc.)
- Excellent command of SQL
- Solid knowledge of one or more of the leading RDBMS platforms (e.g. Oracle, DB2, MS SQL Server, Teradata). Practical knowledge of Oracle would be considered as additional asset
- Solid knowledge of one or more leading ETL platforms (e.g. Informatica PowerCenter, Ab Initio, IBM Data Stage, Oracle Data Integrator, SAS Data Integration Studio, Microsoft SQL Server Integration Services) would be considered as additional asset
- Knowledge of column oriented RDBMS platforms (e.g. Netezza, SAP IQ) would be considered an asset
- Knowledge of multidimensional modeling patterns (e.g. star schema or snowflake) would be considered as additional asset
- Knowledge of banking services business and operating model would be considered an asset
170
ETL Developer, IHC Resume Examples & Samples
- Extracts structured and unstructured data from source systems, transforming it to fit business performance management needs, and loading it into a data mart. Data source formats include relational databases, flat files and non-relational database structures
- Collaborates with business functional leaders by analyzing and evaluating business requirements; diagnose the design, propose/design alternatives and recommendations. Plans and coordinates the implementation of new data requirements
- Oversees the data load production process and the implementation of new data load files in accordance with the department’s change management process
- Ensures data quality by designing and implementing adequate internal controls and monitoring processes. Includes controls to identify individual ETL flows that are performance issues. Ensures controls are maintained when designing new structures by utilizing object naming conventions to encourage consistent development and ease of migration from development to test to production
- Works closely with Information Technology staff through the phases of coding and implementation of external data source files providing clarifications as necessary. Maintains effective ongoing communications with the business and IT community and operational management regarding system plans, projects, budgets, expenditures and policies
- Prepares systems procedures, system operating guides, contingency and recovery plans and maintain technical application level documentation
- Master’s/Advanced Degree in Business preferred
- 4 or more years in banking and financial services
171
Lead Etl Developer Resume Examples & Samples
- 2+ years in a technical lead role
- The candidate must demonstrate senior knowledge and practice with Relational and Dimensional Database development concepts and database life cycle methods and procedures
- Deep knowledge of indexing, partitioning and fragmentation strategies
- Possesses very strong facilitation and evangelizing skills that assisting in translating business needs into effective IT Solutions
- In-depth understanding and experience with ETL, data warehousing/data marts, and design and management processes associated with each
- Must be a data technologist and evangelist for the organization and be able to train and mentor other team members and senior staff
- Highly motivated self-starter, detail and quality oriented and able to work independently and be able to resolve complex problems that have implications beyond your own area
- Bachelor's Degree in Computer Science, Information Systems, or other related field
- 2+ years of experience with big-data platforms and/or data warehouse appliance
- Experience in delivering solutions on premise and cloud technology
- Experience in ETL, reporting and analytics, and business intelligence tools
172
Senior PL / SQL & ETL Developer Resume Examples & Samples
- Help lead and coordinate ETL resources and project activities across the platform
- Maintain and update data warehouse extract transform & Load (ETL) processes using Cognos decision stream
- Develop near real time PowerExchange ETLs
- Understand database design and attribute descriptions
- Performance analyze and tune database functions, procedures and loaders
- Supporting and implementing data integration processes for multiple source systems
- Identification and resolution of problems encountered by the users of the systems
- Work experience within financial management organization
- Excellent collaboration, communications, negotiation, and conflict resolution skills
- Ability to think creatively and seek optimum solutions
173
Datawarehouse / ETL Developer Resume Examples & Samples
- Leading developers for providing DWH Development
- Coordinate with Customer, Technical and various stakeholders
- Design solutions and architecture with assumption and risks
- Obtain approval for design review
- Review ETL process as pre the design and requirement
- Review test cases for UNIT testing
- Prepare other artifacts as required
- Support Testing team and deployment team till project go live
- Mentor Jr members
- Provide KT to production support team
174
ETL Developer Resume Examples & Samples
- Provide analytical support and design data collection processes for workforce analytics including data collection, ETL and analysis
- Integrate disparate data from multiple systems and tools
- Create reports of analytical findings – both written and graphical
- Implement processes and procedures to support, standardize, streamline, and in some cases automate
- Ensure timely and accurate execution of monthly reporting activities, including: reporting, metrics, scorecards, and dashboard reporting
- Assist in development of tools and applications as needed
- Define and design ad-hoc reporting as needed, following reporting standards
- 2 to 3 years of experience in SAS programming and complex ETL
- 2 to 3 years of experience doing data reporting and analysis
- 2 or more years IT Development experience in object-oriented programming
- Knowledge of statistics a plus
- Experience with database consolidation and integration projects
- Expertise in relational database design
- Strong Microsoft Office skills
- Experience with BI and data visualization tools using Tableau a plus
175
IT ETL Developer Resume Examples & Samples
- 1-2 years relevant experience
- Basic knowledge of the business, technical environment, standards, processes, procedures, programming languages and operating systems
- Experience in data oriented solutions including: database, data warehouse, ETL, visualization or analytics
- Ability to code, test and debug unit level programs
- Readiness and motivation to perform tasks under general supervision
- Commitment to and belief in the quality of your deliverables
176
ETL Developer Resume Examples & Samples
- Design, development and integration testing in a Regulatory Reporting tool Axiom Controller View
- Requirements and functional specification documentation for existing or future automation projects
- Interacting with different stakeholders and Project Management team to work on BAU Quarterly and Annual filings
- 5+ years data gathering, data analysis, design and development
- 3+ years in Banking preferably in regulatory projects is strongly desired
- 3+ years in ETL development with complete SDLC cycle. Axiom Controller View experience is strongly desired
- 2+ in SQL, UNIX is strongly desired
- Knowledge of Oracle Database and server migrations is required
- Knowledge of any web technology and scheduling tool is desired
- Expert in data analysis using excel and in using pivot tables is required
- Experience directly communicating with project members and stakeholders on a regular basis
- Must be a team player who works well with technical and non-technical resources
- Must be able to see tasks through to completion without significant guidance
- Prior work experience in Regulatory reporting is a plus
177
ETL Developer / Analyst Resume Examples & Samples
- ETL Developer/Analyst
- Perform analysis, Design and Development of ETL processes using Datastage for Business intelligence and Data Warehouse projects
- Responsibilities will also include providing technical expertise on ETL Design, Data modeling, Data Warehousing and Data Integration
- Handle multiple project assignments with minimal direction and escalate issues as necessary to the management
- Be flexible to respond to changing priorities
- Over five year experience in Datastage and Data warehousing skills
- Strong data design, data modeling and facilitation skills
- Ability to work with cross-functional teams and all levels of Management
- Experience Required: Over five years of experience in Datastage, Teradata, designing and developing ETL applications in Teradata data warehousing environment
- Designing Data Warehousing applications, Writing Specs, data analysis
178
ETL Developer Resume Examples & Samples
- Experience coding in Python
- Experience with REST API's
- Demonstrated knowledge of data models and relational and multidimensional designs
- Demonstrated knowledge of source and target data structures, ETL processes and products
- Experience in problem solving skills
- Demonstrated knowledge of SQL
- Demonstrated knowledge of design review, analysis, trouble-shooting, code review, implementation and integration for applications
- Demonstrated knowledge of functional automated software and current advances in technologies that would enhance the functional performance of the system
- Experience in identifying and resolving problems with computer hardware and software products
- Experience in establishing and maintaining effective working relationships
- Experience in work effectively in a team environment
179
ETL Developer Manager Resume Examples & Samples
- Experience with database development and design including experience with Oracle and/or Sybase
- Source code control software (eg. Clearcase, subversion)
- Code Reviews, Performance, Memory Management
180
Ssis ETL Developer Resume Examples & Samples
- Develop, maintain and support SSIS packages related to the extraction, transformation and loading (ETL) process with SQL Server Integration Services (SSIS) 2012+
- Write T-SQL queries, complex stored procedures and functions to perform database tasks such as inserts, updates and deletes
- Responsible for data profiling as well as SQL and database tuning / optimization
- Provide business and technical analysis, development and project management expertise for business and technology initiatives focusing on Data Warehouse and Business Intelligence solutions
- Develop detailed technical specifications and ETL documentation in collaboration with data warehouse architect and Business Intelligence developers
- Design ETL audit control and scheduling processes
- Develop testing and implementation strategy, conduct appropriate functional and performance testing to identify and resolve process bottlenecks and data quality issues
- Provide expertise and leadership to offsite development team
- Collaborate with Business Intelligence Developers through dashboard and application development process for requirements gathering, feedback on proposed designs and models, and acceptance testing
- 5 - 10 years’ experience, with both hands-on and lead experience in supporting data warehousing solutions
- Bachelor's degree in computer science, information technology or another computer-based discipline
- Must possess the following technical skills
- ETL Tools: SSIS
- Database & Utilities: Microsoft SQL Server 2012+
- Platforms: Primarily Microsoft, some Unix
- SQL Language
- Sales Analytics
- Marketing Analytics
- Accounting / Financial Services
- Data Warehousing Concepts
- Star and Snowflake schemas
- Writing technical documentation
- Software Development Life Cycle
- Knowledge of job schedulers and experience in developing batch and real time integrations (Flat Files, EDI, XML) is a plus
- Knowledge of Data modeling concepts (e.g. Entity Relationship Diagrams) is a plus
- XML/XSLT experience is a plus
- Familiarity with ASP.NET, C# platform is a plus
181
DWH ETL Developer Resume Examples & Samples
- Perform data warehouse ETL-SQL development tasks for large projects (ETL development, stored procedures development, SQL optimization)
- Deliver business and application specific consulting services included in the integrated Teradata solutions
- Support the pre-sale process as well as communicate with the client
- Build data warehouse (DWH) competency
- Experienced in customer interactions
- Self-directed and keen on learning
- Strong problem solving skills and optimization techniques
182
ETL Developer Resume Examples & Samples
- Undergraduate degree in Information Systems (or related program) or equivalent work experience as a systems and/or data analyst at an enterprise level
- Understanding of EDI/ETL and data integration principles
- Understanding of XML document technology and concepts
- The ability to multitask and handle multiple projects simultaneously
- Understanding of command line interfaces (Unix/Linux/Windows)
- Helpdesk or other direct technical client support experience
- Healthcare industry experience, preferably in enrollment data exchange or administration
183
ETL Developer / Data Integration Specialist Resume Examples & Samples
- Bachelor's degree in Computer Science or a related quantitative field
- Experience in software application development
- Strong programming experience in at least 1 language
- Experience with Data Management (Extracting, Transforming, Loading)
- Some exposure to SAS solutions and products
- Experience in technical lead role
- Ability to mentor other staff members
- Ability to comprehend the details of complex system software
- Excellent verbal, written communication skills
- SAS programing experience
- Experience with Java and Java Script
- Experience working with Unix
- Experience with relational and multi-dimensional databases and data management tools
- Advanced report design and build experience
184
ETL Developer Resume Examples & Samples
- 3 + Years of Java experience
- 3+ years of Big Data/Hadoop ETL experience
- 3+ years of traditional ETL experience on RDBMS
185
ETL Developer Resume Examples & Samples
- Development, validation, and support of the ELT/ETL procedures
- Build, analyze, and maintain all data flows and related processes, continually striving to improve them, including increased automation, usability, transparency, documentation, and QA. This includes design, development, and implementation of data structures, database management, data quality, and data warehousing as well as determining data accuracy and determine optimal structure for analysis and reporting purposes. Works with inter-departmental teams to analyze and understand business requirements
- Implementation of data integration and data loading tasks and responsibility for all aspects of data management, ETL, data flows, data quality evaluation and management, and a host of other activities essential to the ongoing operations. Collaborate with business users and IT teams, analyze requirements, apply business rules to data processing and integration and develop functionality by following internal development standards
- Monitors and troubleshoots daily production data loads; diligently identify and pursue data anomalies, correct not just the data but also the source of the corruption; quickly adapt to an ever changing environment, fix issues and support both real-time data flows, and batch/ETL data flows; documentation of technical and system specifications documents for ETL processes; performs unit, regression, connectivity and full end-to-end integration tests; provides technical expertise during the requirements gathering phase of a project
- Bachelor Degree in Computer Science or a related discipline
- Minimum of 3 years hands-on experience with Informatica and experience in ELT/ETL development in a InfoSphere, DB2 environment
- 2+ years of insurance experience in an IT environment preferred
- Knowledge of the business both from a historical/warehouse perspective, and an operational/transactional perspective; ability to understand and analyze the existing system and provide quick solutions to resolve issues and meet new requirements
- Understanding of database and data management concepts as it relates to data movement, ETL development: including dimensional modeling, normalization, indexing and partitioning
- Ability to work in a matrix environment and to value the importance of teamwork
- Understanding of common system architecture frameworks and concepts
- Technical awareness of Security and Application Software Development
- Familiarity with paired programming would be beneficial
- Experience implementing ETL solutions, particularly utilizing Informatica PowerCenter
- Proven relevant experience in systems integration and implementation
- Experience improving Data Quality in Data Warehouses, Operations data stores, Datamarts
- Experience with Informatica Metadata and Business Glossary
- Experience testing ETL solutions and debugging complex software/data integration systems
- Experience Designing Data movement and ETL systems
- Demonstrated ability to liaise with multiple stakeholders
- Experience automating implementations and batch schedules using CAW/ESP Ver12 (Computer Associates Workload Automation tool)
- Strong Database Development Skills, particularly implementing DB2 and SQL solutions. Good experience with large datasets
- Experience working in Agile development software methodology, authoring technical documents / specifications
- Significant experience implementing data-driven systems with large-scale relational or object-oriented databases
186
Lead Etl Developer Resume Examples & Samples
- Lead overall data management solutions and design, change the status quo and create world class information management solutions
- Responsible for the overall integrity of the JH Insurance Data Management environments
- Ensure data management processes are in place to achieve data accuracy, completeness and reliability
- Serve as primary data management escalation point by proactively identifying and managing escalation of potential risk and issues, offering innovate ideas for solutions
- Coach data management/ETL specialists on best practices. Mentor and provide technical guidance for Data Developers. Assist with staff and resource management of project team members
- Liaising closely with data architects, business analyst, data consultants and senior stakeholders across the business
- Data analysis, profiling and development of technical specifications for data loading rules
- Applies data analysis, data modelling, and quality assurance techniques, based upon a detailed understanding of business processes, to establish, modify or maintain data structures and associated components (entity descriptions, relationship descriptions, attribute definitions). Advises database designers and other application development team members on the details of data structures and associated components
- Database, system, data integration, data movement design for efficient information management
- Creation of estimates for new project efforts and project budget management, planning for individual efforts
- Issue resolution & escalation, and project status reporting. On-call support team for handling production issues
- Develops and maintains specialist knowledge of database concepts, object and data modelling techniques and design principles and a detailed knowledge of database architectures, software and facilities. Analyses data requirements to establish, modify and/or maintain object/data models. Evaluates potential solutions, demonstrating, installing and commissioning selected products
- Designs, codes, tests, corrects and documents complex programs or processes and scripts from agreed specifications, and subsequent iterations, using agreed standards and tools, to achieve a well-engineered result. Takes part in reviews of own work and leads reviews of colleagues' work
- Specifies user/system interfaces, and translates logical designs into physical designs taking account of target environment, performance security requirements and existing systems. Produces detailed designs and documents all work using required standards, methods and tools, including prototyping tools where appropriate
- Minimum 7+ years' of Informatica development experience with exposure to version 9.x or later to include
- Certifications with Informatica or other ETL technologies
- Bachelor’s Degree or higher, in a related field such as Information Technology/Computer Science, Analytics, Business Technology
- Project Management training and certification a plus
- Have extensive experience in a data delivery role and use of data tools and intellectual capital in order to hold credibility
- Able to confidently interact with roles ranging from Developers to mid-level managers
- Ability to work in a high pressure, result/deadline oriented environment
- Solid written, verbal, and presentation communication skills
- Strong team and individual player
- Maintains composure during all types of situations and is collaborative by nature
- Ability to shift project priorities as needed to support program objectives
- High standards of professionalism, consistently producing high quality results
- Self-sufficient, independent requiring very little supervision or intervention
- Demonstrate flexibility and openness to bring creative solutions to address issues
187
Ssis / Ssrs ETL Developer Resume Examples & Samples
- 4 years full life cycle development experience
- 3 + years data warehousing experience
- Expertise with SSIS/ SSRS, designing and managing data integration standards
- Data design & development
- Experience in data modeling & data mining
188
ETL Developer Resume Examples & Samples
- Adopt efficient design and development principles to "transform and load" data for MI production
- Provide support to other team members to manage complex requirements
- Develop and validate requirements by adopting an iterative & incremental approach
- Collaborate with BICC teams to resolve queries
- Utilise and promote internal BICC processes
- Provide support to other areas of the BICC as required
189
ETL Developer Resume Examples & Samples
- Designs and develops Informatica mappings within the framework of the warehouse architecture set by the Data Architects
- Implements complex ETL code using Informatica, PL/SQL, Oracle Workflows and Shell Scripting
- Develops and executes test plans to ensure that the ETL process fulfills data requirements
- Assists in Data Analysis and Data Profiling activities
- Provides day-to-day support for operational data warehouse environment
- Ensures compliance with standard software development practices, processes and enterprise standards
- Communicates project/issue status in a reliable and accurate manner through appropriate tools and processes
- Works within IT team to follow the full lifecycle development process working with development and technical operations
- Mentors and helps to develop more junior-level developers
- Bachelor’s degree in Computer Science or equivalent experience required
- Advanced skills using Informatica
- Experience developing PL/SQL packages and procedures
- Proven knowledge of SQL, PL/SQL and Oracle 10g
- Experience working with dimensional modeling
- Experience developing shell scripts and process monitoring in a Unix environment
- Experience analyzing complex source systems and data structures
- Demonstrated ability to deliver software projects of high complexity and risk
- Strong knowledge of systems development life cycle
- Experience in an operational environment
- Strong inter-personal skills and ability to communicate information clearly, concisely, and effectively both orally and in writing, and be comfortable working in a collaborative, team-centric environment
190
ETL Developer Resume Examples & Samples
- Develop Extract, Transformation, and Load (ETL) procedures for implementing data integration and data loading tasks
- Design, develop, test, and deliver code for the project’s user interfaces, system interfaces, and back-end components
- Define, prepare and execute migration packages for new ETL objects
- Develop SQL programs and Stored Procedures as required for the ETL processes and Data Integration activities
- Configure and maintain scheduled ETL jobs
- Provide batch execution support during testing and QA
- Integrate data extraction techniques from various engineering tools to collect and transform relevant data
- Perform data science-type and utility developer functions
- Develop complex Oracle PL/SQL programs for the Data Warehouse
- Analyze transaction errors and troubleshoot issues in the software
- Develop bug-fixes and oversee performance-tuning efforts
- Maintain currency and provide leadership in the use of the newest technologies and techniques such as prototyping, component-based development, object-oriented design, database design, web tools and architecture
- Prior experience providing support to technical teams for ETL processes, and experience developing unit test plans, test cases, and resolve ETL related test problems
- Strong technical and team-focused attributes
- Experience working with SQL, Oracle, PL/SQL, SQL Loader and BI tools
- Ample experience working with Oracle databases and SQL, Postgres, XML, and JSON
- Demonstrated experience developing and maintaining effective ingestion code to receive process, monitor, curate/cleanse, tag, and manipulate high volumes of data
- The ability to work in a mixed technical environment and maintain productivity when switching between languages or technologies
- Self-motivated with advanced extraction, transformation, and load (ETL) and programming skills
- Prior experience meeting aggressive deadlines
- Experience with Java software development
- Experience working in full development lifecycles within an agile environment
191
ETL Developer Resume Examples & Samples
- ) 3-5 Years of experience with MS C#.net. 9Version 4 and above ( currently using 4.62) and MS SQL server. 80% of the time spent in the role will be with MS C#.net and SQL
- ) 3-5 Years of experience with Web technologies, such as ASp.net, Restful, web API
- ) Experience with TFS - Team Foundation Server and MVC
192
ETL Developer Resume Examples & Samples
- Design, develop, code, test, implement and support the data platform
- Design & Develop basic and advanced transformation activities such as normalization, cleansing, aggregation, summarization, and integration; designs automation processes to control data access, transformation and movement; ensures source system data availability and update accessibility, data integrity, restorability and appropriately handles errors, in a time sensitive manner
- Understanding supported business processes, and engage business areas using advanced/expert understanding of business requirements for translation into feasible process
- Verify and support existing ETL code bases to ensure data accuracy. Identify manual processes and automate those
- Manage multiple broader efforts that span multiple projects/initiatives. Prioritize and monitor project/task status and risk management/mitigation, by working with appropriate manager on level of effort/estimates, resource assignments, etc
- Bachelor's Degree in Computer Science, Management Information Systems or related field or equivalent knowledge
- Strong Experience in Pentaho/Kettle is Mandatory
- Hands-on experience with all aspects of designing, developing, testing and implementing ETL solutions using Pentaho/Kettle
- Eperience with with JSON, XML, HTTP, HTML, Web Services
- Experience on a cross-functional team (Agile or other)
193
Business Intelligence ETL Developer Resume Examples & Samples
- Bachelor’s degree in Computer Science, Engineering or Business (equivalent professional experience considered)
- Minimum 2 years’ experience in the IT industry with hands-on continuous work experience in developing end to end Business Intelligence solutions (ETL, reports, dashboards, scorecards) using Informatica and Oracle Business Intelligence technologies or similar Business Intelligence products (like SSAS, SSIS, SSRS, COGNOS, SAS)
- Minimum 2 years’ experience creating SQL queries from scratch (including complex stored procedures) and data processes
- Experience in gathering and analyzing business requirements and translating them to a technical solution
- Ability to quickly learn new systems, adapt and refocus in a fast paced, agile development environment
- Ability to share and grow knowledge across all team members
194
Junior SQL / ETL Developer Resume Examples & Samples
- Determining computer user needs
- Analyzing system capabilities to resolve problems on program intent, output requirements, input data acquisition, programming techniques and controls
- Preparing operating instructions
- Designing and developing compilers and assemblers, utility programs, and operating systems
- Ensuring software standards are met
195
ETL Developer Resume Examples & Samples
- At least 4 years experience with PostGres SQL
- At lease 4 years experience with Informatica Power Center; SQL
- At least 4 years experience with ETL development and process from diverse data sources
- Advanced experience with Informatica Power Exchange Control-M
- At least 4 years experience in development maintenance and enhancement of Informatica Mappings Work-flows and processes
- Experience with Data Warehouse; Oracle; Linux; AIX
- At least 8 years experience designing and developing extract, transform and load (ETL) processes utilizing for example DataStage, Informatica, BigInsights, Pentaho or other vendors
- At least 8 years experience moving/migrating/managing data from operational & external environments to the business intelligence environment based on business rules and requirements
196
ETL Developer Resume Examples & Samples
- At least 2 years experience designing and developing extract, transform and load (ETL) processes utilizing for example DataStage, Informatica, BigInsights, Pentaho or other vendors
- At least 2 years experience moving/migrating/managing data from operational & external environments to the business intelligence environment based on business rules and requirements
- At least 2 years experience working with data warehouses, data marts, operational data stores, data feeds and associated query mining/reporting for business analytics
- At least 2 years experience with data modeling/data workflow diagrams (conceptual, logical and physical)
- Basic Knowledge working with PL/SQL, SQL and Object Oriented concepts and design
197
ETL Developer Resume Examples & Samples
- Works with graphic designers and other members of a project team to develop the site concept, interface design, and architecture of the website. Responsible for interface implementation
- 2+ years of ETL experience using products such as Data Stage or Informatica
- 2+ years of SQL experience
- A Bachelor's degree in Computer Science or related field. Or a Master’s degree in a related field and zero years’ experience. 4 additional years’ experience will be considered in lieu of a Bachelor’s degree
- Creative problem solving abilities and strong work ethic with “can do” attitude
- Ability to take high-level requirements and compile them into development tasks
- Ability to thrive in a team/collaborative environment
- Possess a SECRET clearance or have the ability to obtain one (SAIC will process the clearance for the candidate.) Must have at least an interim SECRET to begin work on the contract
- Must be CompTIA Security+ certified
- Must obtain as a related certification relevant to the computing environment, such as Oracle Certified Associate, with the first 90 days of employment
- Must be enrolled in CompTIA Continuing Education program. Preferred Qualifications
- Experience with PowerBuilder development
- Knowledge of DoD STIGs. WORK LOCATION: Fort Knox, KY
198
ETL Developer Resume Examples & Samples
- 4+ years of experience in the development, maintenance, and enhancement of Informatica Mappings, work
- Flows, and processes
- Experience with Informatica Power Exchange and Control
- M at an advanced level
199
ETL Developer w / Mainframe / Teradata exp Resume Examples & Samples
- Handle all aspects of systems life cycle for ETL processes related to DB2, Teradata and extract files using Datastage, Database and Warehousing skills
- Strong working knowledge in Teradata and data warehousing
- Strong experience in relational databases, advanced SQL and ETL programming/tools/utilities
- Mainframe skills including MVS, JCL, CA7, TSO/SPF, COBOL
- Strong drive for results and ability to multi-task and work Independently
200
ETL Developer Resume Examples & Samples
- Design, develop and implement ETL solutions employing Informatica Power Center and Master Data Management technologies
- Address ETL solution requirements including compliance, security, latency, archiving and lineage
- Design appropriate data staging architectures for fact and dimension data including cleaning and conforming the data
- Develop appropriate meta data storage and management methods addressing business, technical and process data types
- Analyze, design and develop appropriate scheduling and data movement choreography solutions comprehending existing scheduling activities within and between in-scope source systems
- Design, develop and implement robust exception and quality handling capabilities
- Develop ETL solutions that integrate with cloud based applications and data sources
- Incorporate data encryption methods where appropriate
- Performance tuning and optimization of previously implemented SSIS integration packages
- Convert existing SSIS integration packages to Informatica Power Center
- Provide support to technical team, write the necessary required documentation as per the company standards for ETL processes, and develop unit test plans, test cases and resolve related issues
- Undergraduate degree in computer science, management of information science or equivalent combination of education and work experience
- A minimum of 10 years hands-on experience in design and development of enterprise ETL solutions using ORACLE and SQL databases and Informatica Power Center and MS SSIS technologies
- Expert knowledge of SQL Server 2012-2016 and Oracle database technologies
- Hands on Experience with UNIX scripting (FTP, SFTP and Keys exchange, Shell Scripting)
- Previous Informatica Power Center or DIH implementation success highly desired
- Previous Informatica Meta Data Manager, Administrator and alerting capabilities a plus
- Demonstrated expertise with the Application Development Life Cycles, including both waterfall and agile methods
201
Junior ETL Developer Resume Examples & Samples
- Contributes to ETL development solutions, standards, controls, procedures, and documentation. Serves as a team member and works to maintain a positive work environment
- Contributes to ETL design, development and unit testing
- Cooperates closely with the project team to translate client descriptions and ideas into workable solutions
- Contributes to the development of design and coding standards
- Secret clearance must be obtainable
- Minimum 3 years of experience in ETL programming, data management, warehousing, and data mart development including technical development/design experience in complex systems and producing formal implementation plans
- Minimum 3 years of experience developing with any or a combination of the following ETL tools: IBM DataStage, Informatica, Ab Initio, SSIS, Talend, or Pentaho)
- Minimum 3 years of experience in designing processes to migrate data from one environment to another
- Minimum 3 years of experience using Oracle (Version 10g or higher)
- Good understanding of data warehousing, dimensional, relational, and OLAP data modeling
- Attention to detail and maintaining high data quality standards
- Effective at working on small teams and ability to think logically and independently with strong analytical, research and problem solving skills
- Experience with XML data and data exchange implementations (especially the NIEM standards)
202
Ab Initio Etl Developer Resume Examples & Samples
- Incorporate security requirements into design; and provide input to information/data flow, and
- Document the detailed application specifications, translate technical requirements into programmed application modules and develop/enhance software application modules. Participate in code reviews and ensure all solutions are aligned to pre-defined architectural specifications
- Identify and troubleshoot application code-related issues; and review and provide
- Feedback to the final user documentation
- Conduct research to determine if solutions to business requirements currently
- Exist within or outside the business unit, and if not, whether new solutions are feasible
- Analyze impact of proposed data warehouse solutions across the business, develop use cases, functional specification and source to target mappings to demonstrate business requirements to IT team, and contribute a business or process perspective during design reviews
- Facilitate implementation of new functionality through training sessions, demos, and the development of appropriate documentation
- Coordinate with development team to implement data warehouse and business intelligence
- No direct reports and no managerial duties. Individual contributor level position
- Education: Bachelor's degree in Computer Science, Engineering or related technical field
- Experience: 3 years of progressive, post-baccalaureate work experience in job offered or five years of progressive, post-baccalaureate
- Work experience in a software engineering-related occupation
- Experience must include
203
DB / ETL Developer Resume Examples & Samples
- Software Development using iterative / agile methodologies
- Partnering with the Trust and Estates business analysts and existing Application Development teams to understand functional and data requirements for multiple business processes
- Support production rollouts of the functionality on-site by partnering closely with the Infrastructure and Operate team
- Must be detail oriented , needs to be able to investigate and solve for the details independently by partnering with relevant technology or business colleagues
- Experience working closely with AD architects and Design Authorities
- 6+ years’ experience with application development and design
- Must be well versed in database development database interfaces, data analysis, and database performance tuning
- Design, Develop and support database applications
- Optimize tune and make recommendations for database design
- Design solutions using ORACLE, SYBASE, TOAD, SQL Developer
- Maintain and support oracle database instances and applications in high transaction environment
- ETL pentaho and informatica is a big plus
- Develop, implement and maintain change control and testing processes for modifications to databases
- Produce adhoc queries and develop reports to support business needs
- Must be able to work with configuration management to migrate work through all project stages and environments
- Fair knowledge in Java programming
- Ability and inclination to learn & pick-up new tools & technologies quickly
204
Data Architect / ETL Developer Resume Examples & Samples
- Providing recommendations and solutions for improving data accessibility
- Developing data management strategies
- Maintaining and enhancing the existing data infrastructure
- Performing extraction and manipulation of data
- 4+ years of Teradata or SQL Server database experience is required with expert skills in writing advanced SQL, creating packages, leveraging functions, building stored procedures and optimizing SQL queries
- 4+ years experience in ETL tools (SSIS Preferred)
- 4+ years experience in data warehousing & data management
- 2+ years experience in data modeling and demonstrated experience with data driven decision making
205
ETL Developer / Data Integration Engineer Resume Examples & Samples
- Develop and implement the full suite of BI solutions: Reports, Frameworks / Metadata layers, Data Marts, Multi-dimensional Cubes, Dashboards
- Serves as a leader, coach, and mentor to business units on developing their business intelligence reports
- Executes proficiently all tasks and responsibilities. Identifies gaps and provides solutions
- Reviews and provides constructive feedback on the work of others
- Develops innovative approaches for managing capacity and project queues
- Sought out by others as an expert
- Identifies development opportunities for self and clients to promote efficiency
- Has ability to multi-task and prioritize, both individually and for a large team
- Solves complex problems and develops innovative solutions
- Provides explanations and information to others on the most complex issues
- Experience with Data Integration tools (especially Talend)
- 5+ years' experience with developing reporting modules, including dashboards and scorecards within a BI tool (Microstrategy, Cognos, Jaspersoft, Pentaho, Tableau, etc.)
- Experience working with non-relational data. Hadoop, Spark, Mongo, Cassandra
- Good verbal and written communicator. Can meet objectives with minimal supervision
- Bachelor's Degree or equivalent work experience
- Knowledge of health insurance industry
- Excellent organizational and time management skills
206
Senior Oracle ETL Developer Resume Examples & Samples
- Partner with architecture and front end developers to create conceptual designs and detailed technical specifications for data management solutions
- 5+ years of experience working as an Oracle database developer (Oracle Database 10g or greater)
- 5+ years of working in a data warehousing environment, ETL development, PL/SQL development and database performance tuning
- Oracle 11G, Oracle GoldenGate 11g, SAP Data Services 4.2; Data movement architectural patterns, and a thorough understanding of system development lifecycles
- Bachelor degree in computer science or related field
207
ETL Developer Resume Examples & Samples
- Design and develop applications and software tools to automate, improve, or change business processes and procedures
- Serve as a lead developer or Support medium for large sized projects from analysis through implementation by serving as developer
- Involved in project from startup through implementation to ensure all aspects of the technology plan are accounted for, understood, defined and executed successfully
- Build technical designs that properly leverage our architecture
- Effectively give and receive a thorough design and/or code review following documented coding standards and design template
- Develop and perform effective unit testing procedures
- Work with Business Analysts and Solution Managers to address requirement questions
- Work closely with Business Analysts to design scalable solutions to problems
- Work with other team members on medium and large-sized projects
- Work with peers, team leads and supervisors in a collaborative and shared-learning environment
- Work with third party software providers to ensure solutions meet the needs of Ferguson
- Participates in associate meetings and communicates any concerns to management
- Provide estimates for development work and meets deadlines
- Provide mentorship to other developers
208
ETL Developer Resume Examples & Samples
- 3-5 years’ experience designing, developing, testing and implementing scalable, high-performing BI solutions
- Must have experience with one or more BI/Data Integration tools such as Pentaho BA, PDI, OBIEE, Business Objects, SAP Data Services
- Experience working with web application development tools and languages including HTML/XSLT, Java, JSP, JavaScript
- Experience working with relational databases (e.g. MySQL, MariaDB, PostgreSQL, Oracle) and/or column store databases (e.g. MemSQL, Vertica etc.) and database languages including SQL, MDX
- Working experience with application servers (e.g Tomcat, JBoss, Weblogic is a plus
- Work in an Agile development cycle as part of an onshore Scrum team contributing to scoping and estimating discussions, design reviews, code reviews and delivery of functional demos
- Preference will be given to candidates with Pentaho DI and BA toolsets experience
- Excellent communication, presentation, interpersonal skills
209
Ab Initio / ETL Developer Resume Examples & Samples
- General responsibility in the design, development and delivery of human resources data integration between multiple external systems and PeopleSoft, using Ab Initio ETL
- Develop technical solutions to business challenges and functional requirements
- Bachelor's degree in Computer Science or Information Systems or other technically relevant degree
- Experience with Ab Initio ETL Platform (plans, graphs, psets, meta-programming capabilities, etc.)
- Experience with PeopleSoft PeopleTools 8.5x and Integration Broker
- Experience with Ab Initio Express>It, Metadata Hub, Control Center
- Experience with existing Army Human Resources data and systems
210
Senior Business Intelligence & ETL Developer Resume Examples & Samples
- Participate in a full solution development lifecycle including: business case, prioritization, planning, design, development, testing, migration, and production support
- Work within an Agile/Scrum team to develop and maintain standard and ad-hoc reports
- Work within an Agile/Scrum team to develop and maintain data warehouse and ETL processes
- Assist internal business users with developing reports with web-based tools, including OBIEE
- Develop, design, tune and maintain SSIS packages to perform the ETL process
- Assist in strategic placement of business logic within the ETL and/or metadata models
- Work with System Administrators and DBAs to design monitoring and maintain the BI environment
- Commercial software development experience a plus
- Three years of experience with report building, data warehousing and metadata modeling is preferred
- Experience with Jasper Reports
- T-SQL, stored procedures and CTE querying techniques
211
ETL Developer Resume Examples & Samples
- Participate in Design reviews, Test Case reviews, and Production Support readiness reviews for new releases, provide inputs for Go/No Go decision
- Provides team leadership in areas of specific technical knowledge that is frequently sought out by others with significant experience in a single, complex development environment or across multiple platforms
- Assist Service Manager and Service Director in providing management status reports on daily, weekly and monthly basis
- Ensure that all documentation has been updated and that work product meets UDP / SOX compliance requirements
- Assist in Providing estimates on break/fix, and problem-management activities
- Identify application performance improvement initiatives and implement the same in consultation with the Service Manager
- Independent communication with business partners to resolve issues and negotiate project related items such as priorities and completion deadlines
- Document suggestions for continuous process improvements for both OM and development activities
- Provide timely updates on tasks to reporting supervisor
- Adherence to the defined delivery process/guidelines (SLA Compliance etc)
- Adherence to the defined OM delivery process/guidelines (SLA Compliance etc)
- Coordinating ETL strategies with other areas to ensure consistency across the enterprise
- Experience with Datastage is required
- Developing and maintaining standards, common processes and best practices
- Guiding, training, instructing and assisting others onshore/offshore on a variety of technical issues
- Help team members in technical problem of data stage, UNIX and Oracle
- Strong SQL Background
212
Microsoft ETL Developer Resume Examples & Samples
- Responsible for building tables and views in SQL Server
- Responsible for building SSIS packages to load data from source to SQL Server
- ETL Unit Testing
- Documenting entities that have been built
- BI Generalist with strong technical and nontechnical acumen
- 5+ yrs. SQL Server
- 5+ yrs. SSIS
- 5 yrs. experience in BI programming languages – T/SQL, PL/SQL, R, Python, Map Reduce, etc
- ETL technologies
- Thorough understanding of the major components of a BI platform implementation including Data Architecture, Analytics and Delivery
- Minimum of 5 years of experience working on Data warehousing and Business Intelligence projects
- Preference given to candidates with experience with SSRS and other MS reporting tools such as Power View and Power BI
- Self-starter and self-motivated with the ability to prioritize multiple demands
- Strong verbal and written communication skills, including: presentation, meeting facilitation, and documentation skills
- Good organizational, multi-tasking, interpersonal, and planning skills
213
ETL Developer Resume Examples & Samples
- Ab>Initio
- Oracle 10 and 11g
- Unix basics and shell scripting
- L3 Support experience
- Experience in ETL development and implementation
- Well versed with ETL concepts and performance tuning
- Hands on Ab>Initio and Informatica PowerCenter development with design and build of medium to large enterprise projects
- Maintaining and demonstrating a good knowledge of the Financial Services and IT industries, having an in depth knowledge of either several technologies/ systems/ business operations, or expert knowledge of a particular subject area
- Working on a single complex project, or multiple standard projects
- Assisting in the definition and maintenance of middleware implementation level architectures
214
ETL Developer Resume Examples & Samples
- Demonstrated experience in designing ETL processes using Informatica for high-volume, complex data environments
- Data warehouse data modeling experience
- Excellent Written and Verbal skills; Ability to Communicate effectively with all levels especially Executives
- Travel Industry data knowledge experience
- LI-SR
215
ETL Developer Resume Examples & Samples
- Code, test, modify, debug, document, and implement Ab Initio Graphs utilizing the GD Environment and EME
- Adhere to coding standards, procedures and techniques utilizing programming skills and contribute to the technical code base
- Document detailed application specifications
- Create and translate requirements into programmed application modules
- Participate in unit testing and integration testing
- At least 1 year of experience in design and delivery of ETL process development using Ab Initio and Unix shell script
- Proven track record of implementation and delivery of ETL Application
- Hands on experience in PL/SQL programming is preferred
- Knowledge of any of Ab Initio tools like Express>It, Authentication Gateway, Conduct>It, Metadata Hub and EME is preferred
216
ETL Developer Resume Examples & Samples
- ETL and Informatica skills
- SOAP Web Services
- SSO SAML 2.0
- SFTP File Transfer
- 5-10 years of application development and familiarity integrating with 3rd Party applications
- Bachelor’s degree in Computer Science, Information Systems or related field, or an equivalent combination of education and work experience
- Minimum 5 years experience in application integration and development
- Possesses advanced skills and knowledge of development methodologies across various technologies
- Strong technical aptitude and ability to logically analyze and creatively solve complex issues independently
- Ability to effectively communicate both verbally and written to multiple levels of the organization
- Proven ability to lead teams and drive for results through others
- Strong interpersonal skills and ability to work effectively with all levels throughout the enterprise
- Proven ability for influencing current enterprise standards, industry standards, technologies, methodologies and best practices
- Exposure to project management preferred
217
ETL Developer Resume Examples & Samples
- Completes integration development requests for both project and maintenance assignments
- Design, Build, Test and Maintenance of the process to properly load the transformed data into the target database
- 3, Development and Execution of ETL test plans
- Works in conjunction with development lead/manager to determine a strategic approach for each development assignment
- Work with tools and tech such as: lnfoSphere Data Stage CETL), Netezza (EDW), Embarcadero (Data Modeling)
- Follows change management procedures through the development process
- 7, Achieve the SLA’s defined by the team for support maintenance tasks
- Knowledge of Bl-related features and limitations for common database platforms (SQL
- Server, Oracle, 082)
- Ability to plan a solution architecture within an existing client environment
- Knowledge to plan and model data integration processes and to build data modelssupporting complex transformation
- Demonstrates ability to quickly learn new tools based on conceptual understanding of technology
- Exhibits ongoing personal commitment to staying current in field, architecture, technology changes in assigned areas using multiple sources and methods
- Strong analytical and troubleshooting skills required * Excellent planning and organization skills
- Efficiently managing multiple priorities in a fast paced and continuously changing environment
- Ability to work well independently with limited direction * Strong verbal and written communication skills
- Ability to effectively collaborate with business users
- Bachelor’s degree in computer science or related field is preferred * 3-5 years in the ETL technology space
- Emphasis on ETL/Data architecture and modeling for BI and Data Integration services
- Hands-on experience with ETL technologies (e.g. IBM DataStage/QualityStage, Informatica)
- Hands-on experience with Data Warehouse platforms (e.g. Netezza, Teradata, Exadata)
- Proven experience in working with all phases of the development lifecycle
218
ETL Developer Resume Examples & Samples
- Convert designs and specifications into well structured, high quality, useable / re-usable code in a timely fashion
- Understand ETL specifications and build the ETL applications like Mappings
- Create mappings, sessions and Workflows as per requirement of business to implement the logic
- Perform code walk-through and debugging program code
- Perform Unit Testing on developed code / jobs
- Understand and perform Data Analysis, requirement gathering and Design and Development of code
- Create a mapping document based on High level design document
- Assist development team
- Coordinate with development team to create all ETL processes
- Provide an efficient interface for all processes across various platforms
- Evaluate functional requirements and map the documents
- Adhere to defined processes and involvement in process improvements
219
ETL Developer Resume Examples & Samples
- Excellent UNIX and KORN shell scripting skills
- Demonstrated expertise in developing and maintaining complex ETL code to support large data volume movement
- Familiar with system automation techniques and best practices
- Strong knowledge and experience operating within and supporting data processing solutions that utilize Oracle RDBMS
- Excellent planning and time management skills
- 5+ Years working with and supporting the development, maintenance and production of complex database solutions – marketing solutions experience preferred
- Strong knowledge of PL/SQL and Oracle processing environments
220
Digitalisation ETL Developer Resume Examples & Samples
- Designing and documenting the ETL process for both Traditional and Big Data platforms
- Creating data extraction, cleansing and load programs to move data into and out of the Databases and Data Lake
- Working with Agile team members to document and execute test plans for data loading and data validation scripts
- Supporting the code promotion process through development and production as required
- Developing, implementing and maintaining the schedule/dependency logic for automated ETL processing
- Developing monitoring, logging, and error notification processes to ensure data is updated as expected and processing
- Bachelor’s degree in Computer Science, Mathematics or equivalent
- At least 5 years of ETL programming experience required
- At least 3 years of experience in complex SQL with high-value databases
- Solid experience in in a big data environment (Hadoop DFS) as well as with traditional data warehouses required
- Experience with Hadoop (HortonWorks), Talend, Tibco SAP
- Flexible and open minded to change
- Ability to work both independently and contribute to the Team
- English: Negotiation level
221
Data Mart ETL Developer Resume Examples & Samples
- Business requirement gathering and creating technical specifications
- Design and implement Extract, Transformation, and Load (ETL) processes
- Follow change management, deployment and process/procedure documentation
- Experience working with databases ( DB2, Sybase, Oracle, etc)
- Proficient SQL and stored procedures
- Scripting knowledge (UNIX or Perl)
- ETL development experience
- Integrity & ownership, good team player, ability to work under time and
- Informatica Power Designer
- Q/KDB, Greenplum, DB2
- Tableau and Qlikview
222
ETL Developer Resume Examples & Samples
- 3 to 6 years in a development role
- The candidate should be proficient with Oracle PL/SQL, Stored Procedures and Unix
- Non-technical knowledge, experience, and skills (leadership, management, oral, and written communication)
- The candidate must possess excellent communication skills as they will be interacting with people with diverse skills and seniority across different locations and time zones
- The candidate should have strong analytical skills
- Educational requirements: BE/B Tech
- Language requirements (including proficiency levels for speaking, reading, and writing): English - excellent
- Candidate should be willing to be flexible in terms of working hours to have overlap with the India Development team
223
ETL Developer Resume Examples & Samples
- Comfortable working directly with business partners in Marketing, Finance and Operations at all levels of the organization (senior leadership, resort partners, and other technologists)
- A “can-do” attitude to dig into existing challenges, get creative, and efficiently build out solutions across the business
- Ability with and interest in mentoring more junior ETL Developers
- Has experience working with and architecting ETL technologies, specifically Informatica
- Has experience with SQL Server, SQL Analysis Services
- Experience designing and implementing information solutions
- Has experience working with other data integration technologies, such as Data Stage, SSIS, etc
- Has experience incorporating API’s into data reporting experience
- Loves being hands-on in a fast-paced, entrepreneurial environment
- 3-5 years of experience with Informatica Power Center
- 3-5 years of experience with Microsoft SQL Server
- 1-3 years of experience with Salesforce.com, Heroku and Pentaho
- Experience with Master Data Management principles and technologies
224
ETL Developer Resume Examples & Samples
- Collaborate with Investments Operations, Accounting and Controllership teams to construct long term IT solutions to support Genworth’s investment goals
- Support the operation and maintenance of Genworth Investments Accounting Platform (PFI)
- Manage the day to day operation and coordination of systems processes and enhancements
- Code and maintain custom or canned reports, system interfaces and extracts
- Create interfaces and load-scripts to ancillary financial and reporting systems
- Coordinate with project, support, and business analysts to deliver new or enhanced application code solutions
- Collaborate with Business Analysts to create technical/functional test plans and scripts to validate design, development and implementation of system/reporting deliverables, and obtain user sign-off
- Monitor Accounting system related IT processes and ensure successful completion of production daily and monthly runs
- Support the Genworth Investments and accounting functions by trouble-shooting and performing root cause analysis of application problems. Identify action items and make recommendations to address process and/or coding issues
- Monitor process metrics and initiate process improvement efforts for IT processes
- Coordinate the conversion of accounting interfaces, reporting and downstream extracts to the new Enterprise Data Management environment
- Some travel may be required (<10%) between Genworth's Richmond and Stamford facilities
- 2+ years of software development experience and working knowledge of Relational DBMS development using PL/SQL (Oracle) or T-SQL (Microsoft SQL Server)
- Solid experience with Informatica
- Demonstrated expertise in developing complex backend systems using Java, C#, .NET or C++ with solid object oriented programming design concepts
- Bachelor’s degree in a computer and/or finance or accounting related fields
- Minimum 2 years as applications developer
- Working knowledge of System Development Life Cycle (SDLC) and/or Relational Database Management Systems (RDBMS)
- Experience in developing and/or supporting Accounting, Finance, Investments, Portfolio Management and/or Capital Markets systems
- Experience translating functional business requirements to technical specifications (preferably in the finance, accounting, derivative or portfolio management sectors)
- Proven history of detail oriented execution and commitment to customer satisfaction
- Experience and working knowledge in Data Warehouse, ETL, & Hadoop framework components
- Experience or working knowledge of investments accounting systems such as PAM/PFI
- Experience in working with securities & reference data feeds, such as Bloomberg, Thomson Reuters, S&P, Moody’s, IDC, Markit, or similar
- Experience and working knowledge of financial reporting and investments accounting principles
- Experience in supporting complex production application processes
- Experience working in a matrix and distributed environments
- Ability to multi-task, prioritize and execute on assigned deliverables
- Ability to quickly learn new systems and business processes
225
ETL Developer Resume Examples & Samples
- 1+ years of experience with Java and JavaScript
- 1+ years of experience with relational databases
- 1+ years of experience in the development, maintenance, and enhancement of data mappings, work–flows, and processes
- Experience with PostgreSQL, Pentaho Kettle, Accumulo, SOLR, NetOwl, Tableau, and PhantomJS
- Experience with a variety of data feed types, including RSS, SOAP, and REST
- Experience with DoD or IC clients
- Experience as a database administrator
- Knowledge of the Agile software development process, including Kanban
- BS degree in IT, CS, Computer Engineering, or Systems Engineering preferred
- Professional Certifications related to Database Administration, ETL, or Business Intelligence preferred
- DoDD 8570 Compliance, including Security+ Certification
226
ETL Developer Resume Examples & Samples
- Engineer position will support full systems development life cycle for enterprise information management services team
- Research and evaluate current and upcoming technologies and frameworks. Bring innovative new thoughts and ideas to team and help facilitate ideation with team members at various levels
- Support senior technical team in PoCs (Proof of Concept) and help the Department with selection of Vendor Solutions, Technologies, Methodologies and Frameworks. Collaborate with Vendor Resources for Support of Products
- Follow and promote Quality Assurance and Quality Control processes in the department. Actively look for opportunities to enhance standards and improve process efficiency. Ensure adequate test coverage in Unit Testing, System Testing/Integration Testing and Performance Testing. Support senior technical team with Quality Inspections and Walkthroughs throughout the SDLC including Requirements Review, Design Review, Code Review and Security Review to ensure compliance with MasterCard standards
- Partner with globally distributed team to collaborate on day to day activities
227
ETL Developer Resume Examples & Samples
- Enterprise Architecture team provides data and integration services across multiple technology domains within MasterCard Technologies
- Capabilities supported include Master Data Management, Data Integration, Data Quality, Data Transformation, Data Governance and various other enterprise level data integration and information management capabilities
- Associate Software Engineer position will be responsible for the analysis, design, development and delivery of software solutions
- Assists with the creation of documentation such as user guides and software development guides for less-complex projects
- Assists senior team members in the development of web applications, system to system interfaces and complete software solutions
- Significant code development and day-to-day support duties
- Do you have the ability to work in a fast paced environment, are you adaptive to change, and do you possess the through leadership to challenge status quo?
- Do you consider yourself to be an innovator, and do you enjoy the challenge of building sophisticated solutions to solve global business problems?
- Are you motivated to be a part of driving a world beyond cash?
- Associate Software Engineer position will support full systems development life cycle for enterprise information management services team
228
Senior Big Data ETL Developer Resume Examples & Samples
- At least 5 years of experience with design, development, automation, and support of applications to extract, transform, and load data
- At least 5 years experience within a total information technology (IT) environment
- At least 2 years experience with Informatica PowerCenter Big Data Edition (BDE ) or Talend
- Excellent verbal and written communication skills, including communicating technical issues to non-technical audience
- Self-motivated, Inclination to learn new things and ability to adapt and change and make progress
- Minimum of 5 years of experience with Relational databases and working with large data warehouses
- Minimum of 2 years of experience with HortonWorks Framework and Hadoop technologies like HDFS, Hive, MapReduce and experience with developing ETL using these technologies (Talend, SQoop and SPARK)
- Minimum of 5 years of hands-on experience with Unix/Linux shell scripting
- Performance tuning and optimization techniques of Hive QL to process big data from heterogeneous sources
- Excellent Problem solving and Technical troubleshooting skills to provide application support
- Ability to handle multiple projects and prioritize tasks in a rapidly changing environment
229
ETL Developer Resume Examples & Samples
- Work on design and development of large volume data processing applications / operational stores in iterative / agile development model
- Prepare design / solution analysis based on requirements from internal and external sources to evaluate and demonstrate program effectiveness and efficiency, and problem solving
- Research complex functional data / analytical issues
- Utilize Talend for ETL within a Hadoop / Big Data environment
- 3+ years of ETL development experience (SSIS, Informatica, DataStage, Talend, etc.)
- 3+ years of RDBMS development experience
- 3+ years experience designing and implementing effective data strategies in enterprise level data stores, data marts or data warehouses
- Experience working in Big Data / Hadoop environment
- Healthcare industry / claims experience
230
ETL Developer Resume Examples & Samples
- Design and develop Business Objects reports, universes, Explorer Information spaces
- Design and develop ETL from multiple data sources into relational or In-Memory database engine
- Troubleshoot with SAP Business Object Data Services or other similar tools
- Server management and administration including basic scripting
- **An interim Secret clearance is required to begin working onsite with our client, and a Secret clearance must be maintained throughout the project duration. Due to the nature of the government contract requirements and/or clearance requirements, US citizenship is required
- Experience in BI reporting and data migration
- 2-3+ years’ experience in dimensional data modeling, ETL development, and Data Warehousing or data-mart environment
- Excellent knowledge of SQL and Windows/ Linux OS
- Knowledge of Data migration / integration with SAP Business Object Data Services
- Business Intelligence background in SAP Business Object is highly desired,
- Understanding reporting essentials in order to coordinate with and assist reporting teams with issues and/or Server side
- Good knowledge of Oracle database, and/or In-Memory database SAP-HANA
- SAP Business Object Data Services ETL technical capabilities to include experience in implementing and optimizing ETL process using SAP Business Object Data Services
- Knowledge of an Enterprise Job Scheduling software is a plus
- LI-RS1
231
Lead Etl Developer Resume Examples & Samples
- Effectively communicating with customers to gather requirements, resolve issues
- Implementation of automated ETL routines
- The construction of OLAP databases in Microsoft SQL Analysis Services
- User-Defined Functions, etc. in Microsoft SQL Server
- Implementing data marts
- Development of Stored Procedures
- As a successful candidate, you will have skills for the construction and delivery of multi-delivery of multi-dimensional databases, OLAP cubes, Star Schemas, and Dimensional Data Models
- Your experience will include (at least one of) the following tools
- Microsoft SQL Server 2005 Integration Services
- Microsoft DT
- Ascential DataStag,
- Sagent or other enterprise-type ETL tool
- Experience coding, optimizing, analyzing Transact-SQL on a Microsoft SQL Server platform
- Microsoft Analysis Services or other OLAP engines such as Hyperion, Cognos, Business Objects, or MicroStrategy
- Data Warehouse / Data Mart Development
- Experience leading and mentoring a team
232
Junior ETL Developer Resume Examples & Samples
- Bachelor's degree in Statistics, Mathematics, Engineering, Computer Science, Information Technology or related fields
- 2+ years in ETL development
- SQL Scripting Experience
- Knowledge of financial industry data is an advantage
- Statistical analysis and data mining packages such as SAS, SPSS, Minitab or R is an advantage
- Big Data Development experience is an advantage
233
Ssis ETL Developer Resume Examples & Samples
- ETL development
- The primary responsibility and majority of the work will be hands-on development
- Performance tuning and bug fixing (secondary responsibilities)
- Interacting with QAs and UAT Testers and occasionally with PMs
- 24/7 Support (rotation every 5 weeks)
- Strong database SQL experience
- ETL experience - strong preference for SSIS 2012
234
Migration ETL Developer Resume Examples & Samples
- Industrial engineering or computer science graduate - advantage
- Good Knowledge of the insurance business (experience in the actuarial or insurance fields) – advantage
- Experience working with customer’s requirements and to translate them into functional, data mapping/transformation requirement and interface specifications
- Good knowledge of Office tools
- Ability to translate functional requirements to test scenarios
- System analyst with experience in Data Migration or Data Integration - advantage
- Excellent communications skills in English – must
- Personal skills: Independent worker, outside the box thinking, presentable
- Knowledge on K2VIEW or any other ETL tool - must
- Experience working with data models and data structures of complex systems
- Experience in analyzing and implementing interfaces between system - advantage
- SQL knowledge – Must
- PHP experience - advantage
- Experience or degree in programming - advantage
- Agree to travel in some cases extensively
- Experience with overseas customers
235
ETL Developer Resume Examples & Samples
- Five years’ developing and implementing enterprise-scale ETL processes utilizing Informatica and/or Microsoft SSIS
- Extensive experience with data warehouse technologies and implementations such as ETL (Informatica) processes, dimensional modeling, and reporting tools
- Experience with Kimball Dimensional Modeling, Bus Matrix and DW Lifecycle (Facts, Dimensions and SCD’s)
- Experience creating complex ETL data processed in a clear and concise format
- Experience in analyzing query performance issues and modifying data structures or application code to remedy performance problems
- Experience in Oracle 11g with Progress experience a plus
- Experience in Columnar Database Technologies a plus
- Experience working with predictive analytics and statistical software (SAS) a plus
236
ETL Developer Informatica Resume Examples & Samples
- Provide complete life-cycle in designing, developing, implementing and supporting sophisticated BI data manipulation processes
- Proactively analyze and identify problem areas and plan/implement steps for process improvement
- 4+ years of experience with Data Integration Solutions
- Exposure to OLAP, OLTP, Data warehouse, Data mart development, Fact and Dimensional DB designs
- Strong professional consulting skills and ability to communicate well at all organizational levels
- Knowledge of other ETL tools (e.g. SAP Business Objects Data Services/Data Integrator, Informatica, Oracle Data Integrator, or Data Stage) is preferred
- Exposure to Business Intelligence tools such as: SAP Business Objects, Microsoft BI Stack, IBM Cognos, Oracle OBIEE or Microstrategy is preferred
237
ETL Developer Resume Examples & Samples
- Develop relationships with application owners and business partners to understand and translate business requirements into data strategies
- Work closely with Data Warehouse Architect and BI Solution Architect to design data and analytics solutions to increase the usability, completeness, and accuracy of enterprise data
- Develop SSIS and T-SQL packages and stored procedures related to the extraction, transformation, and loading (ETL) of the organization’s data assets
- Monitor and support ETL processes ensuring integrity and proper integration of all data sources
- Research and resolve data, procedural, and technical issues with a sense of urgency
- Responsible for data profiling as well as SQL and database tuning and optimization
- Proactively identify, communicate, and implement opportunities for data integration and quality improvements
- Implement production fixes, support packs, and enhancements; on-call rotation included
- Provide SQL Server database support such as capacity planning, backups, restores, tuning, and user provisioning
- Develop, adopt, and enforce Data Warehouse and ETL standards and architecture
- Write and maintain Data Warehouse and ETL knowledge base documents
- Bachelor’s Degree in Computer Sciences or equivalent education and experience is required
- 3+ years of experience delivering Data Warehousing and ETL solutions
- 3+ years of experience with SQL Server databases
- Strong understanding of data architecture, data warehouse modeling, data integration, data quality, and other data services related to business intelligence environments
- Proficient in SQL and at least one ETL development tool such as SSIS, Informatica, etc
- Detail-oriented drive to investigate and dissect information with a strong focus on quality
- Ability to thrive in both individual and team environment
238
ETL Developer, Junior Resume Examples & Samples
- Creates, updates, captures and edits functional and technical design specifications and solutions to satisfy project requirements
- Provides hands-on technical solutions to business challenges and translates them into process/technical solutions
- Conducts testing and resolves issues found in testing
- Meet deadlines and manage multiple, dynamic prioritiesEDUCATION & EXPERIENCE
- Bachelor’s degree in Computer Science, Mathematics, Information Systems or other technically relevant degree
- One year or more years of experience or equivalent training/studies in system design and development of enterprise applications/systems
- Good understanding of programming concepts, relational databases and experience with SQL development
- Must have strong analytical skills and can demonstrate strong problem solving skills
- Experience in design, development of conversions and interfaces with ETL tools such as Data Stage, Informatica or Ab Initio
- Experience with PeopleSoft or similar ERP Applications
239
Oracle ETL Developer Resume Examples & Samples
- ETL Operations of Oracle 12c DB (L2 support)
- Develop and maintain Oracle PLSQL code necessary to support the ETL processes
- Manage automation of file processing as well as all ETL processes within a job work flow
- Ensure data quality throughout entire ETL process
- To support availability and outcomes of Prepaid system
- Solving incidents & problems in cooperation with internal and external partners (e.g. Business owner, Care/Tech. Support Team, Oracle support, data center operation)
- Operations of essential financial processes (e.g. Month End Closing)
- Metadata Management & Operations Support for BI/Tableau Applications
- Ensuring data quality and data consistency
- Monitoring jobs and run times
- Conducting preventative maintenance of the systems
- Drive system optimization and simplification
- Supporting business power users in system handling and optimizing
- Bachelor's Degree in computer science or equivalent experience required
- 5 years' experience in managing data lineage and performing impact analyses
- Expert ability in SQL, PL/SQL and ETL tools
- Excellent ODI ETL design and documentation skills
- 5 years' experience with ETL tool development to include 2 years' experience with the Oracle Data Integrator ETL tool development
- 6 years' experience with Oracle 10, 11g or 12c
- Unix/Shell scripting knowledge
- Java knowledge a plus
240
AWS / ETL Developer Resume Examples & Samples
- Translating functional and technical requirement into detailed architecture and design
- Coding and testing complex system components
- Participating in code and design reviews to maintain out high development standards
- Candidate should have good on working knowledge on AWS cloud
- Candidate should have AWS Service knowledge with S3 storage understanding
- AWS Pipeline knowledge to develop ETL for data movement to Redshift
- AWS Redshift knowledge for DB design
- AWS Dynamo DB knowledge
- AWS EMR (Elastic Map Reduce) knowledge is good to have
- Candidate should have good knowledge of Data warehouse knowledge
- Candidate should have Data Analysis exp. to map the source to target rules and fields
241
Senior Manager, ETL Developer Resume Examples & Samples
- Strong ETL (extract-transform-load) developer
- 10 years’ experience with Oracle versions including 9, 10 and ODI or MS SQL Server and SSIS or Informatica
- 5 years’ experience in managing data lineage and performing impact analyses
- Expert ability in SQL and PL/SQL
- Responsible for the design and implementation of quality logical and physical ETL designs that have been optimized to meet the operational performance requirements for our multiple solutions and products
- Development of ETL code, metadata definitions and models, queries and reports, schedules, work processes and maintenance procedures
- Design, development, and delivery of data from operational systems and files into a staging area, ODSs (operational data stores), Data Warehouse, downstream Data Marts and files
- Develop and deploy ETL job workflow with reliable error/exception handling and rollback framework
- Manages automation of file processing as well as all ETL processes within a job workflow
- Ensures data quality throughout entire ETL process
- Manage software upgrades, capacity planning and system optimization
- Perform the unit testing, system integration testing and assist with user acceptance testing
- Adapt ETL code to accommodate changes in source data and new business requirements
- Document the ETL detailed design and test results
- Prioritize development and enhancement requests
- He/she has the experience to design the optimal performance strategy, and manage the technical metadata across all ETL jobs
- Ensures compliance with regulatory requirements for data transmission, storage, and data access including documentation, testing, and remediation
- Collaborates with subject matter experts, department Leaders and consultants to define and execute cross-functional data movements
- Able to develop simple, complete useful solutions
- Understand database object development, security and connectivity services, batch scripting, automation, scheduling, real-time processing, columnar data structures and processing, in-memory processing
- Understands delegation of duties requirements
- Modeling and technical design for BI – including materialized views, Stored procedures, reporting views, MOLAP structures
- Understands / worked with master data management and governance
- BS degree, or greater in a computer discipline or relevant certification
- This role can involve working to tight deadlines and when necessary, long hours. IT professionals working in this area may also be needed to be available for call-outs on evenings and weekends
- Problem solving skills and ability to think algorithmically
- Experience working directly with user-group
- Advanced ability in follow-through and task management
- Works in agile environment
242
Interface / ETL Developer, Senior Resume Examples & Samples
- Supports and independently owns tasks related to design, development of conversions and interfaces
- Conduct Unit testing and resolve issues found in testing
- Provides overall technical and logistical support to the program
- At least 2 years of experience in design, development of conversions and interfaces with ETL tools such as Data Stage, Informatica or Ab Initio
- Experience in reading/writing source to target mapping documents
- Strong analytical skills and can demonstrate strong problem solving skills
- Ability to attain active Secret clearance
- Experience with PeopleSoft HCM 9.2
- Experience with DoDAF Artifacts
243
ETL Developer Resume Examples & Samples
- Work under the direction of the Manager to provide technical application solutions for assigned business areas
- Possess technical knowledge of assigned application technology
- Work with Business Analyst to understand the customer’s product-specific requirements and configuration and translate them to technical design specifications and data flow from which programs are developed and coded
- Codes, tests, debugs, implements, and documents programs or technical configuration
- Ensure programs meet technical specifications and standards
- Interact with Business and clinical representatives during the software build or configuration and testing process
- Perform technical application configuration and configure /run reports at user request
- Design and execute unit, system and integration test plans for new developments/releases/reports
- Design, develop, and implement ETL solutions using SSIS
- Data profiling, outcomes reporting, and build solutions
- Maintain technical documentation based on standard operating procedures in support of the assigned application
- Perform application maintenance activities
- Assist in resolving support calls escalated by the Service Desk
- Identify the common causes of the defects, prioritize them and systematically remove them so that they do not reoccur in further development work
- Coordinate with Project Managers to ensure project deadlines are met
- Participate in focus groups and workshops, attend vendor training and demonstrations
- Assist in supporting activations and rollouts
- Consistent efforts to deliver quality solutions as per agreed scope
- Customer focus and close alignment with the customers’ business objectives
- Ensure efforts to continually improve domain knowledge
- Ensure the quality of the deliverables as per the defined standards
- Document issues with resolutions and share with team members to improve team productivity
- Provide data to generate team performance metrics
- Knowledge transfer with other team members to improve overall team education level
- Take complete ownership for the assigned task and timely inform the progress of the project / task to all stakeholders
- Adherence to the defined standards
- Take initiative and drives to bring to logical conclusion; proactive approach
- Provide accurate and timely information and escalates when there are issues
- Actively participate in meetings and make valuable contribution
- BA or BS degree preferred or other relevant combination of training and experience
- 2-5 years health care industry experience focusing Utilization management and Quality reporting preferred
- 5 plus years extensive experience in providing analytical support in assigned product preferred
- 2-5 years of ETL development experience using SSIS
- 2-5 years of hands on MS SQL experience
- 1-2 years of data stage experience preferred
244
ETL Developer, Temporary Resume Examples & Samples
- Write and maintain documentation of the ETL processes via process flow diagrams
- Develop/make enhancements to new/existing data systems and assist with the development of logical data models
- Perform unit testing of ETLs and related components and document test results
- Perform troubleshooting on ETLs and related components, identify application bottlenecks and opportunities to optimize performance
- Provide resolution to an extensive range of complicated ETL-related problems, proactively and as issues surface
245
ETL Developer Resume Examples & Samples
- Strong understanding of relational database structures, theories, principles, and practices
- Understanding of Data Warehousing methodologies and concepts, including and not limited to: star schemas, ETL processes, dimensional modeling and data modeling techniques
- Experience in query performance analysis, and issue detection
- Knowledge of TSQL and exposure to Microsoft SQL Server technologies including SSIS
- Understanding of network topology
246
ETL Developer Resume Examples & Samples
- 3+ years of Development experience, specifically working with ETL
- Strong expertise in SQL Server Integration Services (SSIS) and SQL Server Databases
- Extensive experience working on the full SDLC
- Hands-on experience working with AS400 and Destination
- Expert experience with data extraction and mapping
247
Ssis ETL Developer Resume Examples & Samples
- Deliver projects/work on-time, on-budget, and in a way that accomplishes client goals
- ETL Repository Management, maintain appropriate backups and Multi-project/Multi-concurrent release ETL environment
- Able to read Data Models to translate them into ETL or ELT loads into Data Warehouses and Data Marts
- Analyze source system data to assess data quality. Work with technical and business representatives to determine strategies for handling data anomalies that are identified. Design ETL processes and develop source-to-target data mappings, integration workflows, and load processes. Design, develop, and implement enterprise-class data warehousing solutions
- Use the SSIS platform to extract, transform, and load data. Develop, test, integrate, and deploy ETL routines using ETL tools and external programming/scripting languages as necessary. Write and maintain unit test cases
- Apply creative thinking to identify possible bottlenecks and reporting solution alternatives
- 5+ years of business/technology work experience
- 6+ years of hands-on experience with ETL Processes
- Possess understanding of modern data warehouse architectures and data warehouse modernization techniques
- Good knowledge of BI architecture, data warehousing concepts
- Data Integration Tools: MS SQL Server SSIS
- Knowledge and experience with Informatica products a plus
- Able to critically think and be solution-oriented
- Great organizational, time management and problem solving skills
- Possesses a professional demeanor
248
DWH ETL Developer Resume Examples & Samples
- 2+ years of experience with DWH projects
- Advanced SQL and procedural SQL (PL-SQL) knowledge
- Experience with database systems such as Teradata, Oracle or DB2 in similar positions (DWH ETL development, stored procedures development, DDL scripts, DML scripts)
- Development experience with some ETL tool (e.g. Informatica, Datastage, ODI, Abinitio, etc.)
- Willingness to relocate to Prague, Czech Republic and travel abroad
- EU Citizenship
249
ETL Developer Resume Examples & Samples
- Support the maintenance and development of the extract transform and load (ETL) aspects of the data warehouse
- Maintain an understanding of the inputs received from the data source providers
- Support the analysis, design, development and implementation of new ETL requirements
- Mentor developers in best practices and techniques
- Support testing and validation of the new data conversion processes
- Utilize oral and written skills and strong analytical and problem solving capabilities
- Work in a dynamic environment and have a working knowledge of the SDLC and the associated processes and documentation
250
Data Analyst & ETL Developer Resume Examples & Samples
- Perform ETL development work during iterations. Participate in Iterations, including Scrum meetings, to understand functionality that will be deployed to Production. Complete assigned development during iterations and resolve defects. Develop and maintain documentation according to Data Lake standards. Accountable for quality and timeliness of technical and business solution that meets Data Lake's business needs
- Participate with Dev team for awareness. Reviews Dev plans and Dev tasks after completion as well as test scripts for learning new function
- Perform hands-on data analysis and development using Datastage
- Ability to continue to work on open issues as required (i.e. some issues must continue to be worked through resolution across shifts; some issues are in progress of being worked and require continued follow-up and communication to Super user Community, etc.)
- Perform operational and project tasks related to Production Support activities as needed. This covers tasks such as request analysis, design, documentation, test management and test execution
- Monitor job schedules/check data load schedules and take corrective action for failures. Resolve issues quickly to maintain SLA for report distribution. Conduct initial Root cause analysis for errors and defects, provide as much details as possible when requesting help from others, clearly communicate the status of the issue, including analysis that has been completed and the help that is required to work through the issue. Conduct RCA to determine root cause. Identify preventive measures and implement to avoid future issues
- Write stored procedures and functions as required using the PDA (Netteza) platform
- Log and track defects, respond/communicate with Super users and IBM Teams. Works closely with Super users, provide good responses, timely responses to concerns, questions, issues
- Helping with missing/incorrect data and comparison with the DB. Helping/Testing incorrect functionality issues. Investigate incorrect/missing data issues, functionality issues, US errors or user profiling issues
- Degree in Computer Science or Computer Engineering
- 3-5 years DataStage experience in large Information Warehouse (IW) projects, preferably in Manufacturing / Supply Chain environments
- At least 3 years experiences in Data Analysis
- Good understanding of IBM InfoSphere Data Stage (Data Stage designer, director and administrator)
- Solid Knowledge of SQL, writing stored procedures
- Strong development experience in ETL using Data Stage
- Good understanding of ETL design patterns (load strategies, error handling techniques & data cleansing methods)
- Knowledge of installation & configuration of Data Stage will be added advantage
- Data Modeling concepts (Dimensional and Relational) will be plus
- Experience in Manufacturing or Supply chain centric industries would be preferred
- Experience in DB2 and Nettezza database is a plus
- Solid communication skills, ability to articulate clearly the status, next steps and recommendations
- Self-motivated, proactive, fast learner takes ownership of tasks and works through completion
- Ability to do research, analysis of issue and understand how to analyze the jobs and dependencies to find the cause of the issue
- Collaboration and problem solving skills, analytical thinking and troubleshooting are critical