ETL Developer / Data developer / Informatica Developer

IICS, Informatica, ETL, SQL Server, PostgreSQL, TFS, CI/CD, Cloud, H1-B Sponsor, H1-B Transfer
Contract W2, Contract Independent, 12 Months
$50 - $100

Job Description

ETL Developer / Data developer / Informatica Developer

Job type: Contract

Duration: 12 months.

Note: Client will Sponsor / Transfer H1-B for Suitable consultants.  Must have Real-time experience.

 Key words: IICS, Informatica, ETL, SQL Server, PostgreSQL, TFS, CI/CD, Cloud, H1-B Sponsor, H1-B Transfer

Job Description:

  • 5+ years of experience with Snowflake, Snaplogic, or Informatica.
  • Participate and contribute in the full project life cycle, including: gathering requirements; system design; implementation; testing; deployment; and, support of applications.
  • Create data mapping and workflows using Informatica PowerCenter to extract, transform and load data into the target environments (batch files, databases).
  • Creates Technical design documents and develops test plans for ETL unit testing and integration testing.
  • Work and interact with functional and integration teams on architecture and design.
  • Tune and optimize ETL batch jobs for performance and throughput.
  • Conform to Informatica workflow and mapping standards so that development is done in a consistent manner across all development resources (no hard coding, leverage of mapplet / reuse concept)
  • Develop ETL workflows and mappings from ODS to Datawarehouse using Informatica PowerCenter.
  • Provide development support and mentor junior developers.
  • Assist with troubleshooting ETL batch job issues in production, PreProd, QA and UAT.
  • Work and Support Infrastructure and development teams.
  • Experience in Informatica PowerCenter Installation, Administration and Configuration is a plus.
  • Familiarity with Informatica PowerCenter HTTP Adapter, JMS Adapter, Webservices Hub is good to have.
  • Perform the detailed design of ETL to DataMart (informatica)
  • Analyze data in the data warehouse, data mart or operational systems
  • Perform statistical analysis of business data
  • Load the data into the enterprise data warehouse
  • Support the lifecycle of physical data models and data maps for data warehouse system
  • Perform analysis on the data
  • Support the development and design of the internal data integration framework
  • Create data mappings from source systems to the target systems, data warehouses and data marts
  • Lead the development /integration of the following: data loading for data marts and enterprise data-warehouse
  • Obtaining table designs and analyzing data structures in preparation for data exchanges, and completing data testing for data exchanges
  • Perform data analysis and data profiling against source systems
  • Perform detailed data analysis to understand the source system data
  • Drive the design of solutions for the business
  • Develop data solutions to help the product and business teams make data driven decisions
  • Transform Load) and interface/integration of data into the data warehouse and data marts)
  • Participate in data modeling and data design with BI Tech Lead
  • Support new and existing data using Informatica
  • Develop and maintain data management standards and conventions, data dictionaries, data element naming standards and data dictionary metadata standards
  • Lead development on creating data-dictionaries of key tables and libraries within the data-warehouse
  • Integrating disparate sources of data.
Dice Id : 10171258
Position Id : 7246799
Originally Posted : 5 months ago
Have a Job? Post it

Similar Positions

Informatica Developer
  • Aptino
  • Atlanta, GA, USA
Informatica Developer
  • Ventures Unlimited
  • Atlanta, GA, USA
Informatica Power Center Administrator
  • Codeforce 360
  • Atlanta, GA, USA
SQL Server ETL Developer
  • Revolution Technologies
  • Atlanta, GA, USA
Lead ETL Teradata Developer with Strong SQL Experience
  • Info Dinamica Inc
  • Atlanta, GA, USA
Data Architect
  • The Denzel Group
  • Atlanta, GA, USA
Teradata Developer with Informatica experience
  • Svam International, Inc.
  • Alpharetta, GA, USA