ETL Architect

• Informatica PowerCenter and/or IDMC: mappings, sessions, workflows, worklets and parameterization
• Informatica transformations (Expression, Filter, Router, Lookup, Joiner, Aggregator, Update Strategy) and multi-target loads
• Performance tuning of high-volume, high-complexity ETL workflows (pushdown optimization, partitioning, lookup caching)
• Re-engineering existing ETL after a source-system change, such as an on-premises application moving to SaaS or cloud
• Integration and middleware design: inbound and outbound interfaces, and alternatives where direct write-back is not available
• Data replication and change data capture using AWS DMS or an equivalent tool
• Advanced SQL, stored procedures and schema design on enterprise relational databases
• Data lineage, dependency mapping and impact analysis
• SIT, data reconciliation, parallel runs and cutover planning
• Enterprise job schedulers (JAMS, Control-M or similar)
• Exceptional communication skills for engaging client IT leads, business SMEs and vendor teams, Position: ETL Architect (Informatica) Location: New Jersey (Remote) Type of Employment: Full-Time Compensation: USD 135K+ Purpose of the Position: We are seeking an ETL Architect with deep Informatica expertise to lead the integration and middleware retrofit on an enterprise asset management modernization program for an energy client. As the clients asset management platform moves to a vendor-managed SaaS instance and its legacy reporting platform retires, the role owner will design and lead the re-engineering of Informatica pipelines, the SaaS table replication and the retrofit of middleware integrations, so that operational reporting continues without disruption. Key Result Areas and Activities: Own integration architecture and define standards. Retrofit inbound and outbound integrations. Design SaaS data replication using AWS DMS. Re-engineer and optimize Informatica workflows. Rebuild schemas and remediate SQL objects. Manage job scheduling and workflow dependencies. Lead SIT, UAT, data validation, and cutover activities. Perform data reconciliation and migration validation. Track data lineage and integration governance. Provide project status updates and risk management. Participate in Agile ceremonies and stakeholder reviews. Mentor and support data engineering teams.

Database Extract Transform and Load (ETL), Informatica, Network Routers, Performance Tuning/Optimization, Caching, Database Extract Transform and Load (ETL), Reengineering, Software as a Service (SaaS), Cloud Computing, Middleware Design, * Experience with enterprise asset management (EAM) platforms such as Hitachi Energy Asset Suite, IBM Maximo or SAP PM

• Energy, utilities or power-generation domain exposure, especially supply chain and maintenance reporting
• AWS data services beyond DMS (S3, RDS, Glue)
• Familiarity with BI platforms such as MicroStrategy, Power BI or Amazon QuickSight
• Exposure to migration accelerators or automation frameworks for ETL conversion and validation
• Certifications in Informatica or AWS
• Prior consulting experience on large-scale data migration or modernization programs, * Bachelor’s degree in computer science, engineering, or related field (masters degree is a plus)
• Demonstrated continued learning through one or more technical certifications or related methods
• At least 10 years of relevant experience in data integration, including 4 or more years as an ETL or integration architect

Qualities:

• Self-motivated and focused on delivering outcomes for a fast-growing team and firm
• Able to communicate persuasively through speaking, writing, and client presentations
• Able to explain technical trade-offs to client IT, business and vendor stakeholders
• Able to work in a self-organized and cross-functional team
• Able to make timely design decisions against time-boxed milestones
• Able to iterate based on new information, peer reviews, and feedback
• Able to work with teams and clients in different time zones
• Experience guiding and mentoring data engineers