Overview
On Site
Depends on Experience
Contract - Independent
Contract - W2
Contract - 12 Month(s)
Skills
Informatica PowerCenter
Informatica Powercenter Etl
Workflow
IICS
CAI
CDI
Job Details
Title/Position: ETL Developer
Job Location: Mclean, VA/Dallas TX (Onsite)
Responsibilities:
- Work with internal SMEs to understand overall data architecture in scope for project deliverables.
- Understand all existing integration points within the AWS ecosystem, in scope for project deliverables e.g. Step functions, Dynamo DB, Glue.
- Work with internal support teams Analyze existing ETL process written using Talend and PySpark.
- Develop in scope transformations using Pyspark and IICS.
- Perform Unit testing and assist code promotion to higher environments for user testing.
- Create reusable code for API component (reading from API endpoints):
- Reusable IICS CAI process to retrieve json/xml data from multiple endpoints.
- Reusable pyspark code to populate dimension/history tables in data lake.
Skills required:
- Bachelor's degree in computer science or equivalent is required.
- Dataflux exposure in reading code is good to have.
- IICS is a must. Hands on experience with CAI and CDI is required.
- Informatica PowerCenter background is required
- Multiple years programming experience. Broad understanding of general business and management practices is preferred.
- Complete understanding of all phases of the software development life cycle.
- Expert Knowledge of application design principles, systems development and analysis.
- Advanced Informatica design and development skills using Informatica power center and power exchange.
- Experience in developing Informatica PowerCenter ETL mappings using Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
- Experience using parameter files, parameters/variables and troubleshooting using advanced informatica techniques like session partitioning, push down optimization etc.
- Must be well versed with all Unix commands needed for running ETL jobs as well as for troubleshooting source and target files.
- Prior experience in AGILE environment.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.