IICS ETL Developer jobs in United States
cer-icon
Apply on Employer Site
company-logo

Voto Consulting LLC ยท 14 hours ago

IICS ETL Developer

Voto Consulting LLC is seeking an IICS ETL Developer to work on project deliverables in Mclean, VA or Dallas, TX. The role involves understanding data architecture, analyzing existing ETL processes, and developing transformations using PySpark and IICS.

ConsultingHuman ResourcesInformation TechnologyManagement ConsultingStaffing Agency
badNo H1Bnote
Hiring Manager
Roushan Kumar
linkedin

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

Qualification

IICSInformatica PowerCenterPySparkSQLDataFluxUnix commandsAGILE experience

Required

Bachelor's degree in computer science or equivalent is required
IICS is a must
Informatica PowerCenter background is required
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
IICS
DataFlux
informatica power center
IICS-IDQ
PySpark
SQL

Preferred

Dataflux exposure in reading code is good to have
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

Company

Voto Consulting LLC

twittertwitter
company-logo
Voto Consulting provides professional staffing, consulting, and solutions to all industries including: financial services, health care, logistics, retail, energy, etc.

Funding

Current Stage
Growth Stage
Company data provided by crunchbase