ETL Informatica

1 Week ago • 5-7 Years • Data Analyst • Administrative

About the job

3 skills required for this role

Test your skills to join the top 1% applicants for this job

java

sql

xml

Job Description

Informatica/ETL PowerCenter Developer with 5-7 years of experience needed. Responsibilities include ETL design, creating mappings, workflows, and worklets using Informatica PowerCenter 10.x, source system analysis, data partitioning strategy implementation, versioning of ETL repository, developing stored procedures, SQL queries optimization, data loading from SF Power Exchange, working with XMLs, Java, and HTTP transformations within Informatica, and utilizing Informatica Data Quality. The role requires strong SQL skills and experience with data warehousing objects (type-2 dimensions, aggregations, star schema).

Must have:

Informatica PowerCenter
ETL Design & Development
Data Warehousing
SQL & Stored Procedures
Informatica Data Quality

Good to have:

XML Parsing
Java
HTTP Transformation
SF Power Exchange

Not hearing back from companies?

Unlock the secrets to a successful job application and accelerate your journey to your next opportunity.

Description

Job Description: Informatica/ETL Developer

Primary Skills: Informatica

Role Description: The Informatica/ETL PowerCenter Developer would
need to have at least 5-7 years of experience.

Responsibilities and Qualifications:

- Participates in ETL Design of new or changing mappings and workflows
with the team and prepares technical specifications.
- Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica
PowerCenter 10.x and prepare corresponding documentation.
- Designs and builds integrations supporting standard data warehousing
objects (type-2 dimensions, aggregations, star schema, etc.).
- Performs source system analysis as required.
- Works with DBAs and Data Architects to plan and implement appropriate
data partitioning strategy in Enterprise Data Warehouse.
- Implements versioning of the ETL repository and supporting code as
necessary.
- Develops stored procedures, database triggers and SQL queries where
needed.
- Implements best practices and tunes SQL code for optimization.
- Loads data from SF Power Exchange to Relational database using
Informatica.
- Works with XML's, XML parser, Java and HTTP transformation within
Informatica.
- Works with Informatica Data Quality (Analyst and Developer)
- Primary skill is Informatica PowerCenter
- 5-7 years of experience.
Top Three Skills Required:
- Informatica PowerCenter, Informatica Data Quality.

Education: Bachelor’s degree in Computer Science, Electrical/Electronic
Engineering, Information Technology or another related field
Experience: Minimum 5-7 years

View Full Job Description

Upload your resume, increase your shortlisting chances by 80%