Informatica ETL Developer Resume Sample
Richard Leffler
39797 DuBuque Junctions,
Detroit,
MI
+1 (555) 614 9016
Work Experience
Senior Informatica ETL Developer
04/2018
-
PRESENT
Houston, TX
- Background in investment banking
- Sub Ledger Systems experience
- A good understanding of MS SQL Server 2012/2014 or 2016 and intermediate skills in T-SQL
- Informatica development, Informatica repository, and Informatica Job scheduling
- Experience of performance monitoring and tuning end to end Informatica ETL workflows
- Awareness of production environment criticality and business impact
- Manage day to day development activities on the ETL platform
- Apply best practices and experience to build ETL informatica applications
- Research ETL capabilities as needed to suit business requirements, and provide gap analysis
Informatica ETL Developer
07/2015
-
12/2017
Boston, MA
- Ensures data quality
- Codes, tests, implements, and automates complex processes
- Plans and conducts Informatica ETL unit and development tests; monitors results and takes corrective action
- Oversees basic and advanced transformation activities such as normalization, cleansing, aggregation, summarization, and integration
- Translates data access, transformation, and movement requirements into functional requirements and mapping designs
- Designs automation processes to control data access, transformation, and movement
- Ensures source system data availability and update accessibility, data integrity, restart ability, and error handling
- Leads technical staff and clients to investigate, analyze and resolve complex technical problems related to system functions, environment, and procedures
- Understands existing Informatica ETL environment, translates into new environment requirements and plans tasks to meet those requirements
Informatica / ETL Developer
11/2008
-
03/2015
Chicago, IL
- Plans, installs and configures upgrades of Informatica releases and hot fixes among various
- Provide solutions for data warehousing and Informatica ETL Processes to support Data Integration and Reporting requirements
- Recommends changes to increase scalability and robustness of ETL platforms and solutions
- Monitors and maintains compliance with Enterprise Architecture, Technology Standards, and Disaster Recovery/Business Continuity Planning
- Excellent in Data Warehouse Concepts and work experience
- Excellent ETL Development skills with Oracle PL/SQL
- Strong requirements development (facilitation) and design skills in BI solutions
- Experienced working in a deadline-driven environment, handling and prioritizing multiple tasks
- Work independently or as a member of a team on complex tasks
Education
American Sentinel University
2004 - 2008
Bachelor's Degree in Computer Science
Professional Skills
- Excellent interpersonal, oral and written communication skills are required. Strong communication skills to work with business users and team members
- Strong database experience, data analysis and analytical skills
- Excellent technical, logical, analytical and problem-solving skills to provide insight on development and application support
- Possesses advanced technical knowledge and skills developed through implementation and service experience with PowerCenter and Linux shell scripting
- Strong written and verbal communications skills to work with your team and with our clients
- Strong development leadership skills
- Excellent organizational, interpersonal, verbal and written communication skills
How to write Informatica ETL Developer Resume
Informatica ETL Developer role is responsible for database, design, sql, software, mainframe, retail, training, integration, auditing, refining.
To write great resume for informatica etl developer job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For Informatica ETL Developer Resume
The section contact information is important in your informatica etl developer resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your Informatica ETL Developer Resume
The section work experience is an essential part of your informatica etl developer resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous informatica etl developer responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular informatica etl developer position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative Informatica ETL Developer resume experience can include:
- Effective interpersonal relations skills, ability to collaborate with others and work as part of a team required
- Strong experience in design, development, implementation, administration troubleshooting and support of ETL process using Informatica
- Experience in using Bibucket for version control. Good understanding of CI/CD tools like Jenkins, SonarQube, Artifactory and Ansible
- Experience with SQL scripting languages (SSIS, PL/SQL, etc.) Experience with large enterprise-grade data warehouse solutions
- Great organizational, time management, and problem solving skills
- Strong experience optimizing Informatica mappings, sessions and workflows
Education on an Informatica ETL Developer Resume
Make sure to make education a priority on your informatica etl developer resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your informatica etl developer experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in Informatica ETL Developer Resume
When listing skills on your informatica etl developer resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical informatica etl developer skills:
- Strong SQL skill set with demonstrated experience on SQL Server, Oracle, DB2
- Cooperates with and works effectively with other IT team members
- Experience in data warehouse and data mart environments Experience in developing and deploying Informatica in Unix environment
- Experience participating in the development of Business Intelligence / Data Warehousing systems. Oracle DB experience is required
- Strong experience developing and maintaining Informatica mappings/workflows in a data warehouse environment
- Have strong experience in design, development, implementation, administration, troubleshooting and support of ETL process using Informatica
List of Typical Experience For an Informatica ETL Developer Resume
1
Experience For Senior Informatica ETL Developer Resume
- Demonstrated experience with the Informatica suite of products v.9.x
- Demonstrated experience in data integration; ETL; Informatica V9.0
- Very Solid Informatica Power Center (version 9.X.) experience
- Experience defining, designing and implementing logical and physical data models
- Experience developing and implementing data integration and warehouse solutions in a SQL Server database environment using SSIS & Qlikview
2
Experience For Lead Informatica ETL Developer / Architect Resume
- Experience troubleshooting data integration problems, including data quality concerns
- Miminum 8 years experience working with large Enterprise Data Warehouse projects in the role of Informatica ETL developer
- Direct experience utilizing Informatica PowerCenter
- Experience with many of the transformations of Informatica including complex lookups, stored procedures, update strategy, mapplets, etc
- Skilled in developing Informatica objects - mappings, sessions, and workflows based on design documents
- Experience with ETL tools, including Informatica PowerCenter
- Experience with Enterprise level Data Warehousing
- Capital Markets experience ie. Investment banking, Hedge Funds, Wealth Management
3
Experience For Dataflux / Informatica / ETL Developer Resume
- Experience working with technical and business teams to document data integration/exchange requirements
- To script SQL queries in the source and target system in order to ensure data validation/data reconciliation
- Experience with Salesforce ETL/Data Integrations
- Informatica configuration knowledge/experience
- Experience with Oracle 11, SQL Server
- Demonstrated ability to analyze technical information, evaluate products, services and
- Experience in development, maintenance, and enhancement of Informatica Mappings, Work-flows, and Processes
- Hands-on experience with the Informatica Data Quality (IDQ)
4
Experience For Informatica / ETL Developer Resume
- Informatica Cloud Customer 360 (CC360) experience
- Master Data Management (MDM) experience
- Experience in integration of various data sources like Oracle, SQL Server, Flat Files, XML files and various other data sources
- Three years MS SQL experience required
- Strong knowledge of Agile SCRUM and Kanban methodologies
- Agile delivery, SDLC experience
5
Experience For Informatica ETL Developer Resume
- Experience in related Informatica Tools (TDM, DVO, DQ)
- Supporting existing SSIS jobs to determine performance bottlenecks and fine tuning code and environment as required
- Mapping of data feed to and from SQL server database using Informatica using various connectors
- Conducting unit, functional and integration testing
- Scripting/DB: SQL, PL/SQL; Unix Shell scripting
- Scheduling jobs through scheduler like Active batch
6
Experience For Senior Informatica ETL Developer Resume
- Troubleshooting issues with production jobs to determine root cause and appropriate resolution
- Scheduling Informatica workflows
- Scheduling of the ETL jobs through scheduler and scripts to ensure the correct data flow sequence
- Contributing to test use cases and other related documentation
- Understanding of Interface Concepts (both end-user and data)
- Identify problems, develop ideas, and propose solutions within differing situations requiring analytical, evaluative, or constructive thinking in daily work
- Developed ETL routines using Informatica Power Center and created mappings involving various transformations
7
Experience For Lead Informatica ETL Developer / Architect Resume
- Performance tuning of Informatica Mappings, processes, and load routines. Logical and Physical data modeling
- Has working knowledge of multiple programming languages, tools and technologies
- ETL Design methodologies including best practices, performance tuning, architecture
- Performance tuning of the mapping as per the batch load timings
- Responsible for requirements gathering, resource & cost estimations and developing proof of concepts for business users
8
Experience For Dataflux / Informatica / ETL Developer Resume
- Assist in production support by resolving source data issues and refining transformation rules
- Migration from DEV to QA using Repository Manager
- Provides first/second level troubleshooting, technical and operational support with limited guidance
- Responds to user problems, including issues escalated from more junior team members
- Estimates own work effort for input to project planning
- Builds and maintains working knowledge of multiple business areas and the applications that support them
9
Experience For Informatica / ETL Developer Resume
- Develops for technical data platforms such as DB2, SQL, IMS across multiple operating systems
- Provides support for data movement solutions including extract, transformation, load (ETL)
- Provides product and/or process subject matter expertise necessary to support design, development, testing and execution of technology solutions
- Provide guidance and best practices for testing data movement solutions
- Participate in the full software development life cycle from scoping, analysis, design, implementation, and quality assurance to delivery and support
- Develop and deliver ETL applications using Informatica PowerCenter
- Develop,test and implement ETL applications using Informatica PowerCenter
- Develop and implement technical best practices for data movement, data quality, data cleansing, and other ETL-related activities
10
Experience For Informatica ETL Developer Resume
- Analyze source system data and work with technical and business representatives to determine strategies for handling data anomalies that are identified
- Serve as a mentor and coach to the developer community, fostering a deeper knowledge on industry best practice, standards, and new features of Informatica
- Proficiency with RDBMS systems, SQL, Oracle PL/SQL, UNIX Shell scripting, and database optimizationsSearch Jobs US
- ETL development using Informatica in an Oracle Unix environment
- Create technical design documents that capture source-to-target mapping, define transformation algorithms, and document data quality rules
- Troubleshoot and tune existing ETL solutions
List of Typical Skills For an Informatica ETL Developer Resume
1
Skills For Senior Informatica ETL Developer Resume
- Good Database programming skills (Oracle)
- Strong working experience of the SDLC processes
- Proven hands-on experience in using Informatica components such as Designer, Workflow Manager, Workflow Monitor, Repository Manager, etc Other Knowledge,
- Communicate complex technical concepts effectively, both verbally and in writing
- Prior On-call /Production support experience,
- Strong experience and passion for Business Intelligence and Data Warehousing design principles and industry best practices
- Strong Experience with at least one database architectures such as Teradata, Oracle, or SQL Server
- Effectively identifies and escalates issues as appropriate
2
Skills For Lead Informatica ETL Developer / Architect Resume
- Shares knowledge effectively with team members
- Data Warehouse design and development experience (End to End SDLC experience)
- Strong experience of Database design, models, Oracle, SQL
- Proven track record on performance tuning, identifying and resolving performance bottlenecks on various levels like sources, targets, mapping
- Experience in gathering requirements, analyzing data, provide gap analysis and creating detail design documents and mapping documents
- Good understanding of dimensional modeling and ETL designs for loading Star Schemas
3
Skills For Dataflux / Informatica / ETL Developer Resume
- Experience with ETL software and translating between multiple file formats using scripting languages
- Experience developing solutions and supporting projects from requirements gathering to release management
- Demonstrate results and competence developing ETL processes using Informatica PowerCenter and PowerExchange 9.1
- Several years of experience building and implementing scalable, reliable, and high-performance ETL architectures
- Experience creating ETL design documentation and maintaining overall design document and deliverables
- Experience in debugging mappings and identifying errors and error rows so that they can be corrected and re-loaded into a target system
- Experience working with job scheduler and monitoring tools
4
Skills For Informatica / ETL Developer Resume
- Development experience with Developer/Analyst using profiling
- Possess a solid understanding of each Power Center component: Designer, Workflow Manager, Workflow Monitor
- Strong technical knowledge of Enterprise Data Warehouse, design and development of ETL packages, database design, operating systems and Information Management
- Experience working with informatica for ETL development
- Experience working with AGILE or modified AGILE management & development
5
Skills For Informatica ETL Developer Resume
- Experience with Web Development using Java, Javascript, and Tomcat
- Experience in ETL process using Informatica tool
- Experience working with SFDC objects and Salesforce data migration and integration
- Experience working as part of an Agile team
- Experience using Informatica with web-based/cloud sources and targets (e.g., Restful APIs, NoSQL DB, JSON/XML data formats, etc.)
- Good understanding of data movement beyond functionalities in ETL tools
6
Skills For Senior Informatica ETL Developer Resume
- Perform Unit and Integration Testing and validate results with Business Analyst and end users
- Hands-on experience with Data Warehousing
- QL programming experience
- Demonstrates understanding of application development methods as well as the fundamentals of SDLC
- Extensive experience working with Informatica
7
Skills For Lead Informatica ETL Developer / Architect Resume
- Experience working with Change Data Capture (CDC) technology
- 3-5 experience in following technologies
- Hands on experience on scheduling tools like Autosys
- Experience using Informatica with web-based/cloud sources and targets (e.g., Restful APIs, NoSQL DB, JSON/XML data formats, etc.) is helpful
- Experience in development, maintenance, and enhancement of Informatica Mappings, Work-flows, and processes
- The ability to demonstrate critical thinking to determine root cause analysis
- Development experience with SQL development (DB2, Oracle or SQL)
- Development experience with FTP technology
- At least 7 years experience within an information technology (IT) environment
8
Skills For Dataflux / Informatica / ETL Developer Resume
- At least 5 years experience with design, development, automation and support of Informatica to extract, transform and load data
- Experience with design, development, automation, and support of applications to extract, transform, and load data
- Experience within a total information technology (IT) environment
- Database experience (Teradata, Oracle, SQL Server or DB2)
- Experience with Informatica PowerCenter
9
Skills For Informatica / ETL Developer Resume
- Experience with Informatica Data Quality
- Experience with Informatica PowerExchange (change data capture)
- Experience with ETL and Datamart development
- Integrated Mission Support for Surface Deployment and Distribution Command (ISDDC) Experience
- System administration experience on USTRANSCOM/DOD Programs
10
Skills For Informatica ETL Developer Resume
- Experience with Cognos Development
- Experience with Oracle Development
- Experience on reporting tools; preferably with Qlikview
- ETL development experience; preferably with SSIS
- Good knowledge on Scheduler like ActiveBatch
- Informatica Developer Client (DC) experience
- Desired: Experience working on Agile teams (Scrum)
- Additional: Experience developing on the Salesforce Platform
List of Typical Responsibilities For an Informatica ETL Developer Resume
1
Responsibilities For Senior Informatica ETL Developer Resume
- Strong SQL skillset with demonstrated experience on SQL Server, Oracle, DB2
- Progressive application development and integration experience, supporting medium to larger sized applications
- Have strong business domain knowledge
- Solution Architecture experience
- Experience with Oracle RMS and other Oracle retail products
- A strong business acumen with basic knowledge of Retail principles
- Hands-on experience with Informatica is required
- Hands-on experience with ETL tools
- RDBMS hands-on experience (Oracle, MS SQL, DB2)
2
Responsibilities For Lead Informatica ETL Developer / Architect Resume
- Informatica Powercenter hands on development experience
- Experience in the design and development of ETL workflows
- Experience with large database implementations (Oracle, SQL server, Teradata, IBM, etc.)
- Installing, configuring and administering Informatica PowerCenter v10+ environments
- Scripting/DB: SQL, Unix Shell scripting
- Translating business requirements into detailed technical design documents from which a solution can be constructed
- Documenting data integration processes, programs and solutions per established standards
- Identify reusability across projects by leveraging and customizing the data integration patterns and designing reusable framework
- 5 yrs exp. in business intelligence reporting development using Microsoft SQL Server Reporting Services, Tableau, Cognos, Business Objects
3
Responsibilities For Dataflux / Informatica / ETL Developer Resume
- Enjoys working with others one-on-one and in group settings, both face-to-face and virtually-leveraging technological capabilities
- Develop, document and implement data mappings for ETL implementations using tools such as Informatica PowerCenter, InfoSphere DataStage, or SSIS
- Multiple IT certifications in provisioning technologies such as SQL, Oracle, others
- Comprehensive understanding of the data process requirements, and its impact on business functions
- Learn/adapt new, emerging technologies (big data etc.)
- Professional approach to working with geographically distributed teams, peers and clients included
- Development of new ETL workflows and enhances existing ETL workflows to support various team initiatives
- Batch Scheduling and Autosys set up
4
Responsibilities For Informatica / ETL Developer Resume
- Design and implement full solutions according to Business Requirements
- Support clients BI portfolio with ETL and data mart development using AGILE management and development
- Assist in the providing of the BI portfolio information to other divisions as a service
- Responsible for project’s analytical requirements management and estimations
- Review and analyze functional requirements and prepare technical documents as necessary
- Extensive knowledge of the Systems Development Life Cycle (SDLC) activities specific to data warehousing, data engineering solutions & methodologies and software tools
- Utilize ETL processes to load data from various source systems such as SQL Server, DB2 and Flat Files
- Utilize the Power Exchange to Extract and capture data
5
Responsibilities For Informatica ETL Developer Resume
- Utilize Informatica Workflow Manager and Workflow Monitor to develop, manage and monitor workflows and sessions
- Design, develop and unit test mappings
- Tuned performance of Informatica sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval
- Motivated to take independent responsibilities
- Involved in design, development and maintenance of database for data warehouses projects
- Experience in designing and working with complex data models Strong general SQL knowledge and experience for utilization in query optimization, tuning, and data validation
6
Responsibilities For Senior Informatica ETL Developer Resume
- Assist in the enforcement of Coding standards through code reviews
- Update the project documentation (Change Requests and JIRA's) on the confluence
- Analyze performance of applications and take action to correct deficiencies based upon consultation with users, other technical resources, and the Manager Application Development
- Lead the overall technical direction for medium to large sized projects
- Exposure to any EAI tools like TIBCO
- Escalates issues to the right party when required
- Participates in technical design. Can develop from specifications, under limited guidance
- Produces documentation for changes and enhancements to current systems under limited guidance
- Learns to build productive networks with internal clients
7
Responsibilities For Lead Informatica ETL Developer / Architect Resume
- Escalates delays, issues, risks and highlights to project managers and/or project leads
- Receives general direction. Work in progress is reviewed routinely
- Lead Informatica Development/Data Engg activities
- Design, develop and deliver project, application related activities
- Develop Informatica ETL, Oracle scripts as required
- Lead, participate in level of effort estimations for ETL solutions
8
Responsibilities For Dataflux / Informatica / ETL Developer Resume
- Work with business and IT Teams to plan and deliver solutions
- Design, develop and maintain Informatica workflows and mappings using the appropriate data load technique, including Push-Down Optimization for performance optimization
- Analyzes the impact of changes on existing ETL/ELT processes and systems. Assesses the compatibility with goals in all areas. Analyzes cost effectiveness and feasibility
- Debug and tune data integration processes; analyze data warehouse architecture, normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, dimensional surrogate key handling, exception data processing, troubleshoot and recommend improvements and alternate methodologies
- Experience with data integration architectures, data analysis and implementation
- BI ETL design/development/implementation experience with emphasis on Informatica PowerCenter and SQL
9
Responsibilities For Informatica / ETL Developer Resume
- Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural and requirement specifications
- Design & Development- Provides technical development expertise for designing, coding, testing, debugging, documenting and supporting all types of applications consistent with the established specifications and business requirements in order to deliver business value
- Communicating with internal solution teams and external clients to understand requirements, as it relates to constructing a solution that meets these requirements
- Understanding structure, quality, and compliance of source data with known requirements and coordinate with business and technology staff to identify and resolve issues
- Utilizing SSIS, along with related operating system and database procedures and functions to construct efficient code to transform and load required solution data to our operational staging, warehouse and reporting layers of the data repository stack from disparate source systems
- Tests data requirements for the movement, replication, synchronization and validation of data
10
Responsibilities For Informatica ETL Developer Resume
- Develop dashboards using Qlikview to publish the data
- Based on assignment, requires the technical ability to work in at least one data discipline including data design, data movement, data infrastructure platforms, and data analytics
- Develops data access related to storing, retrieving or acting on housed data
- Uses applied analytics to enable data driven decisions by applying innovative analytic techniques, and providing exploratory research and analysis
- Provides data design/data movement services to help develop solutions that improve overall quality of data and support enterprise data strategies
- Ensures work and/or the work of their teams are in compliance with enterprise policies and policies and standards within their domain of expertise and area of responsibilities
- Design and execute the policies, practices, and procedures that support data quality, data security, data governance, data standardization & integration
- Translates functional and technical requirements into detailed design
Related to Informatica ETL Developer Resume Samples
ETL Application Developer Resume Sample
Work Experience
• Understands customers’ processes and products and how they fit within the goals of the business unit
• Oracle experience with working knowledge in performance and tuning, efficient SQL writing, stored procedures/PLSQL coding etc.
• Play a lead role to facilitate the full prod...
Professional Skills
• Autosys experience or experience with othe...
• Experience writing technical specification...
• Experience in performing general trouble s...
ETL Applications Developer Resume Sample
Work Experience
• Participate in 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 documentatio
• Overall 9+ years of IT experience
• Exper...
Informatica Developer Resume Sample
Work Experience
• Build and maintain job schedules using Control-M
• Provide cost and time estimates for assigned work packages to support the development of time tables and project plans
• Coordinate coding, testing , implementation, integration and documentation of solution
•&nbs...
Professional Skills
• Strong data analysis skills required. Hand...
• Skills in database design with some data m...
• Strong analytical skills (able to read/wri...
Senior Cyber Resume Sample
Work Experience
• Demonstration of deep technical understanding of Cyber/Network Security & Privacy, an Commercial and Technology Errors & Omissions, and Media. Utilizing risk expertise and knowledge of industry and insurance market place, reviews clients’ exposures and loss experience and develops solutions for complex clients’ n...
Professional Skills
• Passion for all things information technol...
• Project and case management skills
• Experience of using common security tools ...
Consultant CRM Resume Sample
Work Experience
• Identify the appropriate stakeholders for your area of work, considering the impact of your work and the broader cross-functional dependencies. Manage these relationships to meet stakeholders’ business needs and align expectations. Always strive to improve business partner satisfaction
• Implemente...
Professional Skills
• Strong Influencing skills and communicatio...
• Global team player, effective and reliable...
• Experience managing global CRM teams and w...
Lead SAP Resume Sample
Work Experience
• Application life cycle management for all Tate & Lyle’s application landscape including roadmaps and Software Asset Management where needed
• Comprehensive understanding of SAP’s customizing toolset
• Work independently as well as a part of a global team
•&nbs...
Professional Skills
• Experience in strong background in formal ...
• Business Analyst experience in functional ...
• Min of 6 to 8 years of experience required...