ETL Engineer Resume Samples

The Guide To Resume Tailoring

Guide the recruiter to the conclusion that you are the best candidate for the etl engineer 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 by selecting wording that best fits for each job you apply

SS
S Satterfield
Susan
Satterfield
507 Nicole Plain
Chicago
IL
+1 (555) 635 1734
507 Nicole Plain
Chicago
IL
Phone
p +1 (555) 635 1734
Experience Experience
04/2014 present
Phoenix, AZ
Senior ETL Engineer
Phoenix, AZ
Senior ETL Engineer
04/2014 present
Phoenix, AZ
Senior ETL Engineer
04/2014 present
  • Work independently in the development, testing, implementation and maintenance of data processes of moderate-to-large size and complexity
  • To provide technical input to MIS incident and problem management
  • Document the data mapping, transformation logic and process flow for each development project
  • Work with software administrators to install, configure and troubleshoot ETL platforms
  • Design, develop, test, debug and deploy code, primarily consisting of data warehouse & data mart contents
  • Design, implement, and execute test plans to ensure highest level of quality is achieved
  • Work closely with Quality Assurance, Operations and Production support group to devise the test plans, answer questions and solve any data or processing issues
06/2011 02/2014
Detroit, MI
Ssis & ETL Engineer
Detroit, MI
Ssis & ETL Engineer
06/2011 02/2014
Detroit, MI
Ssis & ETL Engineer
06/2011 02/2014
  • Design and develop extract, transform, and load (ETL) mappings, procedures, and schedules, following the standard development lifecycle
  • Perform installation, administration, and configuration of SSIS servers in production, pre-production, and development environments
  • Provide Level 2 support and fulfillment of service requests for ETL packages, acting as the primary escalation point for the Service Desk and NOC
  • Perform testing and QA to ensure the accuracy of data
  • Develop and maintain operating procedures and support documentation for ETL packages and the SSIS infrastructure
  • Design and develop data warehouse database schemas
  • Write queries to pull data from WMP systems and analyze it to better understand data quality
12/2007 03/2011
Detroit, MI
ETL Engineer
Detroit, MI
ETL Engineer
12/2007 03/2011
Detroit, MI
ETL Engineer
12/2007 03/2011
  • Assistance with effort planning and on-time delivery of development requests
  • Establishes relationships and effectively responds to competing priorities with key customers, account management and other stakeholders
  • Continuous analysis of existing solution to provide insight into possible improvements
  • Prepares program specifications and diagrams and develops coding logic flowcharts
  • Help define workflows that will include Informatica
  • Performance tune existing solutions as well as solutions in which you will be creating
  • Create mappings to match data to a source system and confirm correctness of data
Education Education
Bachelor’s Degree in Computer Science
Bachelor’s Degree in Computer Science
Northwestern University
Bachelor’s Degree in Computer Science
Skills Skills
  • Strong working knowledge of data-modeling skills, with a solid understanding of entities and relationships
  • Excellent troubleshooting skills with demonstrable experience identifying bottlenecks in existing database/ETL processes
  • Strong understanding of UNIX platforms, and Java programming with shell scripts
  • Ability to write complex SQL and create DB objects like stored procedures, functions, Materialized views, etc
  • Ability to work in a live environment on Oracle, SQL Server and UNIX
  • Extremely strong communication skills –both written and spoken English
  • Strong written and verbal communication skills
  • Excellent analytical and problem solving skills
  • Expert level knowledge and hands on experience in SQL
  • Knowledge on big data is a big
Create a Resume
1

Senior ETL Engineer Resume Examples & Samples

  • 5+ years of experience in data warehousing
  • Strong data modeling and object relational database mapping skill
  • Experience with large scale data integration and data warehousing
  • Hadoop, MapReduce, Pig or Hive
  • Demonstrate the ability to learn quickly if not a core competency
2

Talend / ETL Engineer Resume Examples & Samples

  • New software assessments of Talend Data Integrations products on traditional ETL platforms, and newly emerging GRID, and Big-Data platforms
  • Assisting user-groups, and application-developers on effectively utilizing Talend technologies to solve complex business problems
  • Bench-marking the performance tests, preparing proposals with various Talend ELT proof-of-concept exercises
  • Documenting user/installation guide, operational-documents, and best-practice document
  • Presenting use-cases and project summary to large developer groups
  • Exhibit sound and comprehensive communication and diplomacy skills to exchange complex information
  • Act as advisor or coach to new or junior staff
  • Knowledge/Experience
  • Mandatory Skills
3

ETL Engineer Resume Examples & Samples

  • Expert level knowledge and hands on experience in SQL
  • Sound Knowledge and hands on experience with Informatica Power center
  • Hands on experience working with Oracle/Teradata Databases
  • Experience in handling XML/JSON and other file formats
  • Experience in development environment and production support
  • Shell and Perl/Python/Ruby scripting experience
  • Must be team player and self-motivated, work independently with minimum direction
  • Experience in reporting/Dashboard development is a big plus
  • Knowledge on big data is a big plus
  • 2-3 years of hands on experience in a big data warehouse environment
4

ETL Engineer Resume Examples & Samples

  • Integrate 3 rd party data to Engrade Systems using our proprietary framework
  • Enhance existing reporting for stakeholders
  • Conduct Analysis and gather requirements for new data formats
  • Works on multiple projects simultaneously
  • Establishes relationships and effectively responds to competing priorities with key customers, account management and other stakeholders
  • Anticipates problems and set priorities, manage time effectively, and accomplish tasks within the given timeframe
  • 3+ years of database development using either SQL Server or MySQL (but with significant experience using both)
  • 3+ years of ETL development using SSIS and related tools
  • Solid understanding of data warehouse modern design methodologies
  • Solid understanding of database/SSIS/general software development best practices
  • Experience with very large databases, data warehouses and high-volume ETL processes
  • Experience in all aspects of database design and development, stored procedure development, SSIS development, reporting services development and business intelligence development
  • Experience using linked servers and SQL Server/MySQL data exchange
  • Experience developing with and supporting SSIS server and related tools
  • Experience working with SSIS, SQL Server and MySQL on Amazon Web Services (AWS)
5

ETL Engineer Resume Examples & Samples

  • New software assessments of Talend Big Data Platforms
  • Download software from vendor site, install in LAB, validate and run pre-defined test cases
  • Engineering and Certification of Data Integration/ELT, Data Profiling, Data Quality products
  • Bench-marking the performance tests, preparing proposals with various ELT proof-of-concept exercises
  • Developing scripts/utilities to satisfy data integration functions as needed
  • 5+ years overall IT experience
  • 4+ years ELT development experience
  • 4+ years of experience in UNIX
  • 3+ years Java (certification preferred)
  • 2+ years J2EE
  • 3+ years of experience in MS Office products, such as Word, Excel, PowerPoint
  • 2+ years of experience in technology communication in social media (internal or external)
  • Bachelor of Science & Technology with good Academic
  • Must have good understanding of Talend Data Transformations related to Hadoop Platforms
  • Hands on experience developing ELT jobs using Talend
  • Strong understanding of UNIX platforms, and Java programming with shell scripts
  • Experience of SDLC and ALM tools
  • Experience of Java EMF framework
  • Business Rules, especially Drools
  • Experience with Big Data/ Hadoop is plus
  • Extremely strong communication skills –both written and spoken English
  • Enthusiastic
6

ETL Engineer Resume Examples & Samples

  • Bachelor’s Degree in Computer Science, Information Systems or related field, or commensurate experience
  • Expertise and a keen interest in Data Integration tools, technologies, and approaches
  • Experience building ETL solutions
  • Hands-on experience with Linux (Redhat or CentOS)
  • Data Warehousing & Business Intelligence concepts and solutions
  • PL/SQL and Java programming, UNIX shell scripting
  • Knowledge of MS-SQL and/or Oracle database platforms
  • Experience with EDI data transformations (particularly formats 834, 835, & 837)
  • Incident Management Tools Salesforce, Jira, etc
  • Integration Tools experience: Informatica Power Centre, Pentaho Kettle, Other
  • Knowledge and experience with healthcare organizations, medical terminology and healthcare system business processes is desired
  • Experience in the Quality Assurance (QA) process is desired
7

ETL Engineer Intern Resume Examples & Samples

  • Design, Develop and ETL, Big Data Hadoop, Design and coding across one or more platforms
  • Functions as a member of an agile team and supports consistent development practices tools, common components, and documentation
  • Java, Hadoop, Spark (ideal), NoSQL, MapReduce, Pig, HBase, Teradata, SQL, BTEQ
  • Currently pursuing a Bachelor's or Master's degree from a United States-based college or university
  • Major: Computer Information Systems, Data Analytics, Data Sciences, Finance or a related field
8

Senior ETL Engineer Resume Examples & Samples

  • Gather and interpret system requirements and develop detailed system specifications
  • Design, develop, test, debug and deploy code, primarily consisting of data warehouse & data mart contents
  • Design and implement complex scripts to extract data from a source system, transforms the data, and loads the data into the target database environment using the appropriate data acquisition tools
  • Participates in project reviews in order to provide accurate effort estimates and timeline needed
  • Prepares and modifies routine transformation and query activities according to clear and complete specifications
  • Design, implement, and execute test plans to ensure highest level of quality is achieved
  • Work with software administrators to install, configure and troubleshoot ETL platforms
  • Research and identify root cause of complex production issues. Provide tier 2/3 technical support in partnership with the support professionals. Evaluate and follow through on issues and problems until resolved or escalated
  • Research, evaluate, and recommend software packages for supporting build vs. buy decisions
  • Ensure quality data to the information management environment in a timely manner and maintain the integrity of the data
  • 10+ years of experience working on enterprise level platforms including at least 4 years’ experience developing using Informatica PowerCenter platforms and various components
  • 2+ years of experience working Oracle or SQL based RDBMS and using PL/SQL and query development tools like Toad, SQL Developer etc
  • Domain knowledge in the Banking industry
  • Knowledge of applying data modeling techniques and best practices
9

M HIS Data Developer / ETL Engineer Resume Examples & Samples

  • Assist in the ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL-related activities
  • Creates automated processes to validate and translate data into our in-house data warehouses
  • Need to communicate with the Business Analysts, Data Modelers and Solution Architects when it comes to converting the ETL design into specific development activities
  • Understands and implements best practices, tuning and optimization
  • Maintain existing ETL code
  • Creates technical documentation
  • Workers effectively with data consulting and client services to produce products for the client
  • Participate in daily stand-ups and weekly status reporting
  • Ability to travel 10% if needed
  • Minimum of five (5)+ years of experience supporting large-scale RDBMS applications with ETL tools, complex SQL logic and query optimization
  • Minimum of two (2)+ years of experience with data warehouses
  • Seven (7)+ years of experience working in the design, production, and support of data warehouses
10

ETL Engineer Resume Examples & Samples

  • Experience with software development throughout the SDLC
  • Experience with administering, implementing, testing, migrating, deploying, and managing ETL solutions
  • Experience with Java, Shell Scripts, SQL, XML, and XSLT
  • Experience with core infrastructure technologies, including Linux, Windows, Oracle, MySQL, and PL/SQL
  • Experience with writing monitoring scripts and queries and automating system tasks
  • Experience with working on Scrum or another Agile methodology
  • Experience with Hadoop or Accumulo
11

Data Services ETL Engineer Resume Examples & Samples

  • Design and develop data warehouse solutions, including design, development, and implementation of the data integration / ETL processes
  • Self-starter and willingness to take the initiative and comfortable in a fast paced environment
  • Familiar with data movement techniques and best practices to handle large volume of data. Extensive ETL development experience, preferably using Informatica or Ab Initio
  • Teradata expertise is a must; Extensive knowledge of SQL and performance tuning techniques
  • Familiar with data warehousing architecture and data modeling best practices
  • Knowledge of Unix and shell scripting is highly preferred
  • Knowledge of Hadoop, HBase and Hive is preferred
  • Bachelor’s degree in Computer Science/Engineering or related field with 5+ years of hands-on DW/BI development as an individual contributor, ideally with large-scale database /analytics environment
12

ETL Engineer Resume Examples & Samples

  • Maintaining ETL configuration and baseline within a Windows server environment
  • Troubleshooting issues with ETL connections, performance, or other errors
  • Updating, compiling, testing, and deploying changes in response to problem reports
  • Developing, testing, and deploying ETL modifications based on new customer requirements
13

ETL Engineer Resume Examples & Samples

  • Design and Build of extract, transform and load processes and programs across many different BI systems and projects
  • Creating detailed design documentation, including source to target mappings for a number of different implementations
  • Development of reconciliation procedures and data checks to ensure data quality
  • Applying best practices and reviewing the work of others to ensure the same has been followed
  • Bringing conceptual design down to a level of detail that can be physically implemented
  • Issue resolution of complex issues that cannot be handled by support due to the need to have a deeper technical or process background
  • Data analysis for key focus areas
  • Assistance with testing processes, especially timely resolution of issues
  • Assistance with effort planning and on-time delivery of development requests
  • Ensuring solution operates within broader BI landscape at Biogen, including best practices, consistency, and supportability
  • Interaction with other teams at Biogen (e.g. business, IT functional leaders, infrastructure) to develop a comprehensive solution
  • 8+ years’ experience designing and develop data integration solutions using Informatica PowerCenter
  • 8+ years’ experience working with Oracle (11g/12c) RDBMS
  • Strong development competency
  • Some experience with business intelligence software packages, data management (e.g. data warehousing) is helpful
  • Understanding of business data and methodologies, such as SQL, normalized vs. de-normalized, slowly changing dimensions, databases, data optimization, aggregations, dimensional data modeling, big data, data lake
  • Strong data analysis skills
  • Ability to dive into difficult technical issues
14

M HIS Senior Talend ETL Engineer / Architect Resume Examples & Samples

  • Bachelor's Degree or higher from an accredited university
  • Minimum of seven or more (7+) years of experience supporting large-scale RDBMS applications with ETL tools, complex SQL logic and query optimization
  • Minimum of seven or more (7+) years working with one (1) or more of the following ETL Tools: Informatica, SyncSort DMX, Data Stage, AB Initiio, or Talend (Talend Strongly Preferred)
  • Minimum of seven or more (7+) years of experience with data warehousing methodologies including dimensional modeling
  • Minimum of eight or more (8+) years of experience in BI, ETL and Big Data projects, full data lifecycle experience
  • Strong knowledge of Java preferred
  • Continuous Integration and Continuous Deployment experience is a plus
  • Cloud or AWS experience is a plus
  • Talend or Informatica ETL and Healthcare Data experience strongly preferred
  • Experience in analysis, data relationships, data aggregation and summarization with the ability to consolidate data from disparate systems is preferred
  • Knowledge of elastic cloud computing environments such as Amazon AWS and Azure
  • Lucene experience
  • Restful API, ELK stack experience
  • Hl7, CCDA, FHIR, X12 experience
  • Tomcat and Apache experience
  • Amazon S3 API Experience in a large enterprise environment
  • Knowledgeable in SOA and ROA architecture
  • Knowledgeable in Java JAX RS REST services
  • NLP knowledge and experience
  • Big Data Analytics experience
  • Windows and *.nix environments
  • Knowledgeable in leading Amazon technologies such EC2, Lambda, Glacier, S3
  • Bash Shell
15

ETL Engineer Resume Examples & Samples

  • Purging of stage tables and temporary tables
  • Proactive monitoring on the performance of ETL jobs and working with server/network/DBA teams to resolve issues
  • On call Support weekly alternating between primary and secondary
  • Depending on the support schedule prepared by Johan
  • Review requirements with BA’s (Tammy/Nicole) to analyze impact and provide estimates
  • Develop, test, deploy, and provide post-production support for new ETL jobs
  • UNIX Shell Scripting for new requirements/debugging and tuning existing code
  • Troubleshoot and debug issues when there are data mismatches between ODS and source systems (Evavi, Viaware and IFS)
  • Identify root cause and provide fix to avoid repetition the issues
  • Performance tuning - Oracle SQL queries and objects
  • Performance tuning - Pentaho transformations and jobs
  • Provide guidance/support to Middleware team on new or existing feeds that pull data from ODS
  • Provide guidance/support to Web Focus team on new or existing reports that pull data from ODS
  • Create/Modify Daily Monitoring Report queries for monitoring the data movement between the systems
  • Identify/Analyze/Resolve one-off scenarios without making impact to the existing processes
  • Ability to work in a live environment on Oracle, SQL Server and UNIX
  • Design, development , performance tuning and support of ETL, Database jobs and UNIX scripts
  • Ability to write complex SQL and create DB objects like stored procedures, functions, Materialized views, etc
  • Data Mapping and reverse engineering skills
  • Prior experience with administration of Pentaho a plus, but comprible application experience accepted
  • Strong working knowledge of data-modeling skills, with a solid understanding of entities and relationships
16

Senior ETL Engineer, Product Development Resume Examples & Samples

  • Design and Execute Unit Test plans and document results
  • Develop and manage project schedules/project work plans, as well as lead design and development reviews
  • Ensure performance metrics are defined, met and tracked, and conduct QA reviews
  • Maintain and develop project standards, quality control, and documentation
  • Experience in marketing analytics and marketing ad tech
  • Experience with Hadoop, Hive, Pig, Presto, Spark
  • Minimum 3-5 years’ experience with one or more scripting languages. Must be VERY comfortable with Python; if it is not your primary language, you must demonstrate an ability to quickly become an advanced user
  • Minimum 3-5 years’ experience with SQL, including significant Postgres or Redshift experience
  • Must understand how to apply advanced techniques such as regex matches, date transformations/truncations, and window functions in one or more SQL variants
  • Experience writing ETL/ELT procedures and transforming large data sets, preferably “from scratch” using a scripting language
  • Strong understanding of data modeling and data warehousing principles (OLAP and dimensional modeling)
  • Experience writing scripts to retrieve data from REST and/or SOAP APIs
  • Experience and understanding of complex ETL/ELT workflows and directed acyclic graphs
  • Must have an ability to independently track down data sources and the contacts required to get access to them
17

Principal ETL Engineer Resume Examples & Samples

  • Led design and development of data warehouse solutions, including design, development, and implementation of the data integration / ETL processes
  • Interact closely with other BI development teams like Data Architecture / MDM, Technical Services to deliver scalable applications
  • Own the design and development of ETL frameworks, build reusable components, and be responsible for data flow strategy, and performance tuning
  • Be a subject matter expert and provide consultation to business partners such as analysts, management, end users, and developers to clarify requirements, determine scope / estimates, drive design discussions, code reviews, and performance tuning
  • Mentor and coach other team members, review their code and provide technical guidance
  • Experience in designing / developing large scale data integration preferably on MPP platforms
  • Expert in data movement techniques and best practices to handle large volume of data. Extensive ETL development experience, preferably using Informatica or Ab Initio
  • Demonstrated skills and hands-on experience in defining data warehouse architecture, physical data modeling, and leading projects integrating various disparate data sources
  • Programming background using Unix/Shell, Python is highly desirable with strong understanding of performance, scalability, and concurrency
  • Strong analytical skills including the ability to define problems, collect data, establish facts, and draw valid conclusions
  • Experience with Scrum/Agile methodology is preferred
  • Bachelor’s degree in Computer Science/Engineering or related field with 8+ years of hands-on DW/BI development as an individual contributor or team lead, ideally with large-scale database /analytics environment
18

ETL Engineer Resume Examples & Samples

  • Bachelor’s degree in Computer Science, Math, Engineering or equivalent degree required. Masters Degree in Computer Science, Math or Engineering preferred
  • 2-3 years working in the Microsoft stack, including experience using C#, .NET 3.5/4.0
  • MS Visual Studio 2010 or higher
  • MS SQL Server 2008 or higher, ETL, SSRS, T-SQL
  • MS .NET Framework 3.5 or higher
  • C#.NET, VB.NET, ASP.NET, JavaScript, HTML 3/4/5, CSS
  • Demonstrate a solid understanding of database design principles as well as Multi-dimensional databases
19

Senior ETL Engineer Resume Examples & Samples

  • Develops software (hands on code development) to meet key business objectives
  • Designs and develops SW applications or systems solving specific business or processing problem (Web or Mobile)
  • Gathers business requirements and develops conceptual design and technical design for multiple projects concurrently
  • Reviews computer system capabilities, work flow and scheduling limitations to determine if requested program or program change is possible within existing system
  • Provides guidance, performs code reviews and ensure quality deliveries for self and application engineers. Participates in build vs. buy evaluation process
  • Provides architecture and design overview in adherence to SW development standards
  • 3-5 years Application Development Experience
20

ETL Engineer Resume Examples & Samples

  • Engage with Internal clients to clearly define business requirements and assist in the design of ETL processes
  • Follow quality assurance guidelines including the documentation, review and approval of all project related artifacts
  • Troubleshoot client and operational issues quickly and comprehensively
  • Comply with standards and guidelines related to the design, construction, testing and deployment activities within the Delivery Management environments
  • Demonstrate collaborative skills working within a project team of diverse skills and will bring communication skills including oral, written and presentation skills, creativity, and problem solving skills to a challenging environment
  • Improve upon existing ETL processes
  • Perform regular systems maintenance and improvements as needed
  • Responsible for analysis and improvement of system security
  • Report project status timely and accurately from week-to-week
  • Works with minimal guidance; seeks guidance on only the most complex tasks
  • Be available for afterhours support and code releases
  • Bachelor's degree in computer science, business or other relevant degree; OR equivalent experience of 5 years minimum in one or more aspects of information systems operations and maintenance
  • 5+ years of Data/Technical analysis experience
  • 5+ years of IBM Infosphere DataStage ETL tool (version 8.5.x or greater)
  • 5+ years of experience with SQL on relational databases, preferably Oracle, DB2, and SQL Server
  • 5+ years of UNIX or Linux experience
  • Extensive experience with ETL system architecture, system design and data flow
  • Experience with 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
  • Master's degree in computer science, business or other relevant degree
  • Exposure to complex, cross-departmental projects involving multiple platforms
  • Healthcare industry knowledge
  • Experience with other ETL and EDI solutions such as IBM Sterling B2B Integrator, Ab Initio, or Talend
  • Exposure to EDI 834, 835, 837
21

ETL Engineer / Admin Resume Examples & Samples

  • Experience in configuring datastage security both at tool level and Unix level
  • Working experience with cross-functional teams and IBM support
  • Excellent analytical & troubleshooting skills and have experience in analyzing WAS & Engine tier server logs
  • Experience in ISTools & ISALITE command line utilities
  • Very good with UNIX commands and shell scripting
  • Experience with databases such as Oracle, SQLServer, and DB2. Should have worked with XEMTA database
  • DataStage
22

EDW ETL Engineer Resume Examples & Samples

  • Over 5 years as an ETL Developer in data warehouse environments
  • Familiarity with data warehouse and BI architecture, methodologies, and best practices
  • Strong track record of successful project delivery in data warehouse/BI environments
  • Expertise in Informatica and other data ingestion tools
  • BS in Information Technology or other related degree
  • Ability to work effectively in an onsite-offshore delivery model
  • Experience working in a Scrum model would be a plus
  • Experience working on AWS would be a plus
23

ETL Engineer, Business Intelligence Resume Examples & Samples

  • Responsible for development and implementation of Informatica Power Center mappings, change data capture or delta extraction and workflows using various data sources (SAP ECC, SAP BW, Oracle, AS/400, Sql Server, AX 2012, others) following standard practices. Experience with SAP Source systems is required as we have multiple SAP ECC instances supporting different divisions
  • Responsible for leading project efforts and providing overall governance while working with external developers, implementation partner teams and offshore resources. Apply appropriate methodologies to support the creation and maintenance of Informatica ETLs, and create and execute test scripts to ensure quality delivery
  • Performs day-to-day administration of Informatica platforms, monitoring Informatica services and platforms, maintaining Informatica users and other standard Informatica administration functions
  • Provide day-to-day production support for Informatica ETL jobs and monitor performance to ensure service level agreements with our business be met and perform tuning as needed to improve data refresh timelines. Drive the resolution of problems in a timely manner and has good experience in troubleshooting issues and debugging ETL mappings. Must be experienced in managing multiple priorities and escalating issues/risks to management and senior leadership
  • Ability to translate business requirements and / or produce functional requirements, requirements matrix, support documentation for Informatica
  • Responsible for determining the scope of work, estimating efforts and providing time estimates for new projects and enhancements
  • Responsible for gathering and articulating requirements while interacting with different teams. Complete analysis to understand data flow, overall BI requirements and validate design with business requirements to ensure completeness of solution
  • Working with vendor support and various groups within IT and support partners to drive resolution of issues on production support and project activities
  • Providing production support on existing Sql Server, MS SSIS ETL packages and ability to debug and reverse engineer SSIS packages, stored procedures. Create/Enhance / Modify SSIS packages as necessary to meet urgent and critical business requirements
  • Responsible for Informatica capacity planning and forecasting the growth of Informatica environments with new projects/enhancements to meet SLA's in a rapidly growing, changing and complex environment
  • Ensures the support team is prepared to support and manage new Informatica capabilities at Go Live
  • Works with delivery teams to design scalable, flexible IT solutions. Ensures adherence to agreed upon architecture standards and guidelines
  • Adheres to and supports all IT policies, processes and methods. Perform all quality and validation activities in compliance with the internal and external requirements / standards for Health & Safety, Quality, Regulatory and Finance
  • 7+ years’ experience in Informatica PowerCenter, Power Exchange, BCI development. Specifically, Informatica version 8.6 or higher; experience in Data Explorer and Data Quality. Data Archival techniques, and implementation experience a plus
  • Strong experience in ETL design and configuration from various data sources (DB2,Oracle, SAP, SSIS, MS Axapta)
  • Strong experience in ETL workflow design, error handling, and developing quality metrics reports for batch job processes
  • Proven record of accomplishment of contributing at a senior level on large-scale data integration initiatives from idea through benefits realization is required
  • Solid experience in business transformation rules to support business process for Finance, Sales, and Marketing
  • Deep experience in structured project execution and management, preferably in regulated or medical device industry
  • Strong English language skills required; fluency in one or more additional languages – French, German, Spanish, etc. – is a plus
  • Leadership: The resource must be seen as a credible business partner by peers and senior leadership. Strong leadership will be required to develop the new Information Technology organization and to perform effectively as a global shared service
  • Management Skills: The resource must be able to manage a global multi-cultural virtual team of experienced technical staff. His/her direct reports and staff will be responsible for delivering high quality, on budget, within schedule technology enabled global business solutions as a global shared service. He/she must have demonstrated technical matrixed organization management experience
  • Communication & Influencing:The job holder must clearly convey information and ideas through a variety of media to individuals or groups in a manner that engages the audience and helps them understand and retain the message. An individual with excellent interpersonal skills and influencing ability who can win the confidence of individuals at all levels, both inside and outside of the organization. Program Manager must coordinate with ITLT communications person concerning enterprise communications
  • Teamwork:An individual who can work effectively in a collaborative environment and foster teamwork with their peer group, their team and with business / functional leaders. Job holder must be comfortable with working in an environment with influence without authority
  • Technical Expertise: The job holder must have a background in successful information technology systems development, systems management, project management and solution delivery
  • Business Acumen: The job holder should possess strong analytical and process management skills and have a broad understanding of group business strategy and operations. He/she must be able to clearly articulate the business value proposition for all IT enabled business solution initiatives considered by the Investment Management process
  • Requires ability to concentrate on detailed technical tasks for sustained periods of time
  • Use bullets for each point for physical, manual, audible/visual Requires the ability to operate computer, printer, copy machine, calculator, other general office equipment, and to record written information
  • Requires the ability to communicate with customers, users, and vendor representatives in person and on the telephone
  • Requires the ability to participate in interactive verbal group activities including brainstorming and application design working sessions
24

Senior ETL Engineer Resume Examples & Samples

  • To be the technical point of contact for the MIS Oracle environment
  • To ensure the integrity of data held within the MIS database(s)
  • To provide technical input to MIS incident and problem management
  • To work with MIS representatives within the non IT functions to provide required technical support
  • To support the promotion of best practice in the creation and delivery of the MIS service
  • Experience of working across all SDLC phases – from source data to ETL architecture to database report delivery to systems maintenance
  • Extensive experience of delivery of an MI service and data modelling
  • Demonstrate the ability to be objective in handling problem resolution
  • Mentoring junior members of the team
25

Lead ETL Engineer Resume Examples & Samples

  • Support the total design and implementation effort and participate in multiple projects, consistently solve complex problems, and have assigned responsibility for mentoring, support and technical project leadership for more junior engineers
  • Solve complex problems and make design decisions with focus on Performance, Scalability and usability Lead the design of software solutions, including applications design, database design, data-flows and detailed technical design working with the Solutions Architect as appropriate. Ensure that analysis includes working with the Enterprise Architect to factor in the wider view of technical and business impact
  • Produce accurate and unambiguous functional and technical documentation of products, systems and services prior to and during development. Ensure the continuing accuracy of those documents during their lifetime, with the aim of providing services that fulfil product and operational requirements
  • Actively participate in the definition of scope of projects and estimates of timescales for development and operational/technical evolution work, which will allow the Scrum Master / Project Manager to factor them into all overall delivery plan/backlog with the Product Owner
  • Balance the commercial needs of the business against the ideal software design, proposing sound phased or tactical implementations balanced against a baseline of 24x7 support and monitoring
  • Take ownership of the identification of issues, risks and dependencies pertaining to testing and follow up their escalation through your team through to resolution
  • Be responsible for coaching and mentoring the software engineers and test engineers within the team to support continuous improvement in our software, testing and design processes and practices
  • Work with the Senior MI Manager and Business Analyst to ensure that software processes follow an agreed model (SDLC) throughout the delivery of an individual project. Ensure that project reports are accurate and reflect known risks and issues to enable progress to be properly reported
  • Constantly seek to improve the quality of 3rd party processes and deliverables
  • Actively work with the Senior MI Manager, Software Engineers and Test Engineers to provide an end-to-end regression testable solution that enables automated unit and behavioural (BDD) testing to be run as part of the standard build process
  • Expected to lead a single piece of work, or several streams according to business needs. This will include close working with other internal design, development or 3rd parties to deliver larger projects or programmes
  • Commercial ETL experience, handling large datasets
  • Experience with relational databases such as Oracle, SQL Server etc
  • Understanding of data structures as they relate to business behaviour
  • Interpret and negotiate business requirements to deliver high quality, customer focused testing solutions
  • Ensure that software solutions are fit for purpose, fully regression testable and therefore cost effective, delivered on schedule and to functional and non-functional specifications
  • Work with external software vendors to ensure their products are well-defined, are testable within our defined testing framework and are fit for purpose
  • Define software methodologies and standards to ensure that solutions are high in quality and success is repeatable
26

ETL Engineer Resume Examples & Samples

  • To deliver new functionality to MI through Project based change and BAU small change
  • To identify and implement performance to all aspects of IT MIS provision
  • Educated to Degree level ideally in an IT subject or discipline
  • Experience of working with Oracle and Oracle Warehouse Builder (11G)
  • Experience of ETL (Extract, Transform, Load)
  • Experience of working with multiple data sources
  • The ability to work under pressure and to set and work to strict timescales
  • Exposure to DB2 or Business Objects (XI3.1) advantageous
27

Integration ETL Engineer Resume Examples & Samples

  • Develop integration scenarios using the Eclipse IDE to graphically orchestrate integrations
  • Strong communication skills to gather requirements, produce specification documents, and operational documentation & knowledge transfer
  • Monitoring of integration scenario quality and performance
  • Coordinate with Testing leads to consult on the creation of Testing Strategies
  • Coordinate with Release Management to plan and prepare testing environments and data seeding on project-by-project basis
  • Participate in team reviews of design artifacts and code, make changes as required, and recommend alternative solutions where appropriate
  • Design, code, unit test, system test, performance test, debug, implement, and support application systems either through new development, enhancement of existing systems, or 3rd party products
  • Work with technical and functional teams to ensure effective delivery of systems
  • Follow established processes for configuration and release management to ensure that all project artifacts are managed, integrated, and versioned according to standards
  • Bachelor’s Degree in Computer Science or Information Systems field (or equivalent work experience)
  • At least one year of experience using an integration platform such as Informatica, Mulesoft, etc and related platform components such as
28

Ssis ETL Engineer Lead Resume Examples & Samples

  • Participate in data warehouse design, creation, and monitoring to ensure that data is clean, accurate, available, and complete
  • Participate in production support and code deployment outside of regular business hours
  • Take on end-to-end ownership and perform different roles within analysis and development phases
29

Ssis ETL Engineer Resume Examples & Samples

  • Analyze and create complex SQL and SSIS as needed to support new and evolving data integration projects and data extracts
  • Coordinate development of ETL/data warehouse best practices needed to support new and evolving sources of data used in reporting, transaction processing, and analytics
  • Perform extensive and detailed data analysis necessary to ensure strict adherence to data quality guidelines
  • Set and manage expectations with clients while providing proactive communication and status updates; prioritize deliverables with client/requestor, and follow/implement change control and release management processes
  • Adhere to general work requirements and perform other duties as assigned
  • Understanding of and experience in database administration
30

Senior Big Data ETL Engineer Resume Examples & Samples

  • Analyze, design and develop appropriate scheduling and data movement choreography solutions using multi-tenant, highly available software components
  • Actively participates in requirements, architecture, and design meetings
  • Enjoy a healthy technical debate but know how to collaboratively solve problems that move everyone forward
  • Communicate well in person, over email, and via instant messenger within the team and with other development teams to improve quality, advance standards, and handle issues
  • Work efficiently and collaboratively in an Agile (Scrum or Kanban) team environment
  • Directly and meaningfully impact the experience of students, institutions, and professors
  • Improve and maintain internal monitoring, instrumentation, and overall visibility of our learning systems
  • Be self-directed and be able to prioritize your own workload
  • Be willing to learn new skills whether they are directly tied to software development, software testing, server maintenance, or application release and delivery
  • Patient. You will need to work directly with several application teams, product owners, and management levels to develop project strategies and deliver code
  • Smart. Problem solving is more than just knowing the code; it includes knowing how to approach unique problems
  • Analytical. You will need to be able to analyze requirements, code, and issues to devise strategies and understand solutions
  • Motivated to Share knowledge - We are building learning teams that take the knowledge gained from each experience they go through and use it to better the team's performance. Our team members need to embrace this and use every success and failure to improve the collective intelligence of the group
  • The ideal candidate will be detail oriented, self-directed, self-motivated, with a strong capacity for working successfully and flexibly with members across the organization
  • 7+ years of industry-standard ETL development experience
  • Strong understanding of the principles of Data Warehousing, including the use of Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling
  • Experience in big data technologies like HDFS, MapReduce, Hive, Pig, Spark, Kineses, Firehose, S3, Redshift
  • Strong SQL and Unix experience
  • Experience and interest working in cloud based environments and managed services preferred
  • Experience with Debian, Jenkins, and automated deployments a plus
  • Experience in Java programming a plus
  • Easy to work with, stays confident and optimistic in face of challenges
  • Strong communications skills and the ability to communicate technical concepts to non-technical people and work with a variety of internal and external development groups
31

ETL Engineer Resume Examples & Samples

  • 5+ years of experience with ETL software, including translating between multiple file formats using scripting languages
  • 2 years of experience with Informatica
  • Knowledge of methodology, federal information system policies, including NIST 800.53, FISMA, the Security Technical Implementation Guide (STIG), configuration management) and the client’s mission and processes
  • Experience with SAS tools
  • Experience with Big Data or Hadoop tools and technologies
32

Ssis ETL Engineer Resume Examples & Samples

  • Create and analyze complex SQL and SSIS (as needed) to support new and evolving data integration projects and data extracts
  • Take on end-to-end ownership and perform different roles within the analysis and development phases
  • Set and manage expectations with clients while providing proactive communication and status updates; prioritize deliverables with clients/requestors, and follow/implement change control and release management processes
33

Junior Ssis ETL Engineer Resume Examples & Samples

  • Design and support database and table structures for new and evolving sources of data
  • Perform extensive and detailed data analysis to ensure strict adherence to data quality guidelines
  • Set and manage expectations with clients while providing proactive communication and status updates; prioritize deliverables with the client/requestor, and follow/implement change control and release management processes
34

ETL Engineer Resume Examples & Samples

  • ETL architecture, design, development, and implementation
  • Supporting the Informatica environment operations, including, but not limited to: automation, job scheduling, dependencies, monitoring
  • Coordinating multiple ETL workflows and data load processes and monitoring/administering systems performance, including on-going optimization and tuning of Informatica implementation
  • Supporting and enhancing existing Informatica environment and developing new, complex ETL processes to support additional design, development, and deployment of the Enterprise Master Data Management system
  • Analyzing and evaluating data sources, data volume, and business rules
  • Designing and implementing complex ETL processes
  • Comprehensive proficiency with Informatica in a DB2, Oracle Database and mainframe environments
  • Very good understanding of Software/System Development Lifecycle methodologies and the ability to successfully deliver Informatica assignments.     
35

ETL Engineer Resume Examples & Samples

  • Create mappings to match data to a source system and confirm correctness of data
  • Help define workflows that will include Informatica
  • Document all solutions created
  • Performance tune existing solutions as well as solutions in which you will be creating
  • Work with multiple teams, development and business, to create solutions designed around their needs
  • Help define how Informatica can and will be used within the Enterprise
  • Define and implement strategies to allow for unit testing of mappings and workflows
  • Help define and implement strategies for integration and QA testing
  • Advise team members on how to use, implement, deploy, and troubleshoot Informatica
  • Define best practices within Enterprise Informatica implementations
  • Continuous analysis of existing solution to provide insight into possible improvements
  • Knowledge of how to invoke workflows from external sources
  • SQL queries and optimizations
  • Deployment and confirmation of successful deployment to multiple environments
  • Informatica MDM
  • Microsoft Visual Studio and Team Foundation Server
  • Source control experience
  • Implementing solutions within Informatica
36

Senior ETL Engineer Resume Examples & Samples

  • Gather requirements from Operations and Products to define data definitions, transformation logic, and data model logical and physical designs, data flow and process
  • Design, develop, and test data processes per business requirements, following the development standards and best practices
  • Develop, test and automate metadata upload/download, data quality control applications, release procedures using various technologies available, including Abinitio, SAS, Oracle SQL and PL/SQL, Unix Shell Scripts, andHadoop
  • Work independently in the development, testing, implementation and maintenance of data processes of moderate-to-large size and complexity
  • Work closely with Quality Assurance, Operations and Production support group to devise the test plans, answer questions and solve any data or processing issues
  • Document the data mapping, transformation logic and process flow for each development project
  • Work closely with Operational users to solve any issues in the data
  • Bachelor degree in Computer Science, Engineering or related fields. Masters preferred
  • 5+ years of directly related and progressively responsible experience with Database technologies (such as Oracle, Sybase or SQL*Server) and proficient in SQL and complex queries
  • 2+ years of experience with UNIX platform and proficient in Shell programming
  • Experienced and In-depth programming skills in at least one of the following languages on UNIX: Java, Ab Initio, SAS, C/C++, Oracle PL/SQL or Hadoop
  • Experience in complex data modeling and data mining is a plus
  • Strength in data analysis and detailed oriented
  • Ability to influence others and operate effectively in a matrix organization
  • Ability to work both independently and within a team environment
  • Strong written and verbal communication skills are a must
37

Ssis & ETL Engineer Resume Examples & Samples

  • Work closely with internal stakeholders as part of a development team to evaluate requirements and develop business intelligence and data warehousing solutions
  • Design and develop extract, transform, and load (ETL) mappings, procedures, and schedules, following the standard development lifecycle
  • Design and develop data warehouse database schemas
  • Coordinate activities with data source application owners to ensure integration and data integrity
  • Perform testing and QA to ensure the accuracy of data
  • Write queries to pull data from WMP systems and analyze it to better understand data quality
  • Perform installation, administration, and configuration of SSIS servers in production, pre-production, and development environments
  • Develop and maintain operating procedures and support documentation for ETL packages and the SSIS infrastructure
  • Provide Level 2 support and fulfillment of service requests for ETL packages, acting as the primary escalation point for the Service Desk and NOC
  • Maintain updated ticketing for events, incidents, requests, changes, problems, etc
  • Experience developing sophisticated SSIS ETL packages against complex systems and data sets
  • Experience with financial, HR, and marketing data sets preferred
  • Experience installing, administering, and maintaining MS SQL Server and SSIS infrastructure
  • Good knowledge of standard concepts, best practices, and procedures within a data warehousing and business intelligence environment
  • Bachelor’s degree required - Computer Science, MIS or equivalent
  • Experience with IT Service Management and DevOps concepts and methodologies preferred
  • Ability to engage Level 1 teams (Service Desk and NOC) to support data and analytics functions
  • A desire to work within a fast-paced, collaborative, and team-based support environment
  • Ability to work well independently or on a team of 3-5
38

Senior ETL Engineer / Data Wrangler Resume Examples & Samples

  • Layers of Full Stack
  • Proficiency in at least one of the scripting languages: Perl, Python or others (ideally in the context of data processing or data science)
  • Perform data discoveries to understand data formats, source systems, file sizes, etc. This will include engaging with internal and external business partners in the discovery process
  • Experience with ETL and/or other Big Data processes
  • Experience with a variety of data modeling practices for OLTP and OLAP
  • Expert level proficiency in SQL
  • Ability to perform complex data analysis with large volumes of data, ideally with MSSQL or PostgreSQL and batch loading processes
  • Understanding Server, Network, and Hosting Environments
  • Some Web or RESTful API experience preferred
  • Degree in Computer Science, Software Engineering, or equivalent
  • Strong interpersonal and communication skills, a good work ethic and sense of humor
  • 5+ years of engineering experience in a professional environment. Skill fit is weighed as a higher priority than simple work experience
39

ETL Engineer / Data Wrangler Resume Examples & Samples

  • Perform data discoveries to help learn and maintain enterprise processes
  • Ability to multitask given a wide-variety of business requests
  • Some experience in at least one other programming language: C#, Java, Perl, Python or others
  • Comfortable understanding of Windows environments
  • Degree in Computer Science, Software Engineering, or equivalent work experience
  • Good work ethic with an attitude of making the workplace an enjoyable place to be