Job Details

ID #45866488
State Georgia
City Atlanta
Job type Contract
Salary USD $50 - $100 50 - 100
Source Competent Systems, Inc
Showed 2022-09-21
Date 2022-09-20
Deadline 2022-11-18
Category Et cetera
Create resume

ETL Developer / Data developer / Informatica Developer

Georgia, Atlanta, 30301 Atlanta USA

Vacancy expired!

ETL Developer / Data developer / Informatica Developer

Job type: Contract

Duration: 12 months.

Key words: IICS, Informatica, ETL, SQL Server, PostgreSQL, TFS, CI/CD, Cloud,

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.

Vacancy expired!

Subscribe Report job