Senior ETL Informatica Developer Resume Samples

A Senior ETL Informatica Developer uses specific Informatica Software for designing and overseeing data storage systems. For executing this core task, several roles and responsibilities are undertaken by the developers and such are listed on the Senior ETL Informatica Developer Resume as – loading, testing, and troubleshooting data, analyzing and testing data warehousing systems; resolving issues within the systems, creating technical documentation, conducting data quality tests; developing technical documentation for Informatica systems; and performing data cleansing procedures.

Apart from needed technical skills, the following are certain other qualifications expected from job applicants – a thorough knowledge of computer programing, coding, and various operating and systems; the ability to quickly develop data warehouse systems; and strong knowledge of programming languages, data platforms, and Informatica PowerCenter tools. Potential developer should hold a degree in computer science. Additionally, it would be helpful, if the candidates have an Informatica Certification from an accredited Institution.

Senior ETL Informatica Developer Resume example

Senior Etl Informatica Developer Resume

Headline : Experience in Requirement Gathering and Analysis, System Design and Development phases of Software Development. Strong experience in Data Warehousing experience using a Power Center.

Skills : Technical Skills, Analytical Skills.

Description :

    1. Acted as the basic input for the migration process and the loading is done through the LDMS.
    2. Mapped a sheet will be developed based on functionality and application behaviour.
    3. Contained the schema of a particular Care Activity [CA] and the corresponding mappings from the source system.
    4. IFF will be created based on the UI-DB input.
    5. Contained the functional, mapping and schema details.
    6. Mapped and transformation are done on Informatica or DTS [Data Transformation Services].
    7. Approached is based on the target system Lorenzo irrespective of what the source system is.
    8. Generated can be used across different source system and is generic for any source system.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors


Jr. Senior Etl Informatica Developer Resume

Objective : Enjoy creative problem solving and getting exposure on multiple projects, and would excel in the collaborative environment on which your company prides.

Skills : Data Quality, Data Warehousing, Data Analysis.

Description :

    1. Proposed to retire the legacy system and move all the Medicaid enrollment details to new system CURAM.
    2. Medicaid card and Eligibility flat files are generated to send to MMIS for Medicaid benefits.
    3. Sourced data comes flat files, DB2 databases, and external feeds, and data is extracted.
    4. Discussed the business requirements with State resources in determining MedicAid Eligibility.
    5. Developed Informatica mappings, sessions, workouts, and workflows to extract Human Demographics.
    6. Created ETL mappings to migrate data from the legacy ANSWER system to the CURAM system.
    7. Transformed and Loaded into Staging tables and move ultimately to Target databases.
    8. Developed Slowly changing dimension (SCD Type-2) to get the delta changes and insert/update records.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor's In Electronics


Senior Etl Informatica Developer III Resume

Summary : Focused industry experience in IT with a strong background in Oracle Database development and Data Warehousing and about process using Power Center.

Skills : Analytical Skills, Management.

Description :

    1. Required to build an ETL and BI application for the Canadian System.
    2. Decided Teradata database system for Canada.
    3. Data from different operational sources, data mart, and then transformed and loaded it into a centralized data warehouse.
    4. Flatbed files and is then loaded into Teradata as a target database using Informatica-Power Center.
    5. Applied to Extract, Transform, and Load the data into the Data Warehouse.
    6. Gathered and documenting Functional & Technical specifications.
    7. Developed must be experts at taking a big-picture view of a company's data situation.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Bachelors

Senior Etl Informatica Developer/Executive Resume

Objective : Experience in the industry. Enjoy creative problem solving and getting exposure on multiple projects, and would excel in the collaborative environment on which company prides.

Skills : Data Warehousing, Data Analysis, SQL.

Description :

    1. Medicaid eligibility details and Human Services information in a legacy system ANSWER.
    2. Proposed to retire the legacy system and move all the Medicaid enrollment details to new system CURAM.
    3. Extracted, transformed, and loaded into CURAM and then eventually into IDS databases from which the Medicaid card.
    4. Sourced data comes flat files, DB2 databases, and external feeds, and data is extracted using ETL tools such as Informatica Powercenter.
    5. Discussed the business requirements with State resources in determining MedicAid Eligibility and Enrollment for Citizens.
    6. Developed Informatica mappings, sessions, workouts, and workflows to extract Human Demographic data from a variety of sources.
    7. Created ETL mappings to migrate data from legacy ANSWER system to CURAM system using Intermediate Database Store.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Communication

Senior Etl Informatica Developer/Analyst Resume

Objective : Exposure on optimizing the SQL and performance tuning using Explain Plan. ETL developers are responsible for designing and creating the data warehouse and all related extraction.

Skills : Communication Skills, Organized.

Description :

    1. Gathered and documented Functional & Technical specifications.
    2. Analyzed existing logical and physical data modeling with STAR and SNOWFLAKE schema techniques using Erwin in Data warehouse.
    3. Partitioned tables that have frequent inserts, deletes, and updates to reduce the contention and to improve the performance.
    4. Maintained development, test, and production repositories using a repository manager.
    5. Designed the Data Warehousing ETL procedures for extracting the data from all source systems to the target system.
    6. Extensively used Transformations like Router, Lookup (connected and unconnected), Update Strategy, Source Qualifier, Joiner.
    7. Worked extensively with dynamic cache with the connected lookup Transformations.
    8. Designed and optimized the Mapping to load the data in slowly changing dimensions.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors

Senior Etl Informatica Developer/Director Resume

Objective : Seasoned IT professional with proven technical skills. Experience in information technology, with specific focus on Data Architecture, Data Modeling, Data Conversion, Testing, design.

Skills : Management, Technical Skills.

Description :

    1. Responsible for the development and maintenance of applications with technologies involving Enterprise Java and Distributed technologies.

    2. Collaborated with developers, product managers, business analysts, and business users in conceptualizing.

    3. Assisted in the definition, development, and documentation of software's objectives, business requirements.

    4. Collaborated with the QA team to define test cases, metrics, and resolve questions about test results.

    5. Assisted in the design and implementation process for new products, research, and create POC for possible solutions.

    6. Developed components based on business and/or application requirements

    7.Created unit tests in accordance with team policies & procedures

Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
MS

Asst. Senior Etl Informatica Developer Resume

Objective : Experience in all aspects of software development and systems management - including analysis of project, development, deployment, testing, implementation and documentation in various industries.

Skills : Communication Skills, Analytical Skills.

Description :

    1. Experted in Informatica and should have used various transformations in Informatica

     2. Reviewed the informatica programs to ensure that high levels of quality are being met.

     3. Experienced in ETL migration projects. Excellent Communication and Presentation Skills.

    4. Reviewed the Informatica jobs to ensure that high levels of quality are being met.

    5. Experienced with JSON, XML formats.

    6. Able to understand complex SQL queries, procedures, and functions.

    7. Experienced on other ETL tools such as Pentaho and DataStage etc.

Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Masters

Associate Senior Etl Informatica Developer Resume

Objective : Informatica developers analyze a business's database storage and warehousing capabilities and assess the company's data requirements.

Skills : Analytical Skills, Organized.

Description :

    1. Implemented of High Availability ( HA ) and Disaster Recovery planning.

    2. Performed Tuning of MDM Real-Time and Batch Processing.

    3. Mentored application team members and junior administrators.

    4. Provided Subject Matter Expertise in the Informatica suite of products including but not limited to PowerCenter.

    5. Supported and troubleshooting of Informatica MDM and ETL Server implementations.

    6. Installed and configured Informatica environments, upgrade Informatica server software (as required).

    7. Performed root cause analysis of any platform issue and resolve the issue. Work with Informatica vendor support if required.

Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
BS

Lead Senior Etl Informatica Developer Resume

Objective : Design, develop, and test data processes per business requirements, following the development standards and best practices as well as participate in code peer reviews to ensure our applications comply with best practices.

Skills : Technical Skills, Management.

Description :

    1. Experienced in setting up and tuning Informatica Powercenter Services.

    2. Experienced with various operating platforms, metadata management, and good experience with SQL and ETL.

    3.Handed-on Knowledge of various Informatica administration activities, security, backup, performance tuning.

    4. Provided effective and timely communications to users, infrastructure team members of system downtime, outages, and issues.

    5. Worked with Development and Solution team to assist with implementation & rollouts.

    6. Assisted ETL users with issues related to access, configuration, or any other Informatica infrastructure-related issues.

    7. Experienced in setting up and tuning Informatica Powercenter Services.

Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Diploma

Senior Etl Informatica Developer Resume

Objective : Solid understanding of the software development process, including requirement gathering, analysis/design, development tools/technologies, release/version control, contemporary testing methodologies.

Skills : Leading Skills, Management.

Description :

    1. Planned for effective execution to meet the stringent timelines.

    2. Worked closely with architects and developers and QA engineers to discuss and evangelize features.

    3. Collaborated with geographically dispersed, cross-functional teams in an Agile environment.

    4. Participated in internal/cross-team meetings, scoping, decision-making, and technical documentation.

    5. Proactively identify architectural weaknesses and recommending appropriate solutions.

    6. Co-ordinated with L2 and L3 support for application bug/ enhancement requirements.

    7. Ensured high quality of all development work; following the development process without guidance, but with reviews.

Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Diploma