SeniorAdministrator - Extract Transform Load (ETL), Data Lakes

Job Summary

This individual contributor is primarily responsible for translating business requirements and functional specifications into software solutions, for assisting in contributing to and leveraging the technical direction for the development of integrated business and/or enterprise application solutions, and for providing consultation to help ensure new and existing software solutions are developed.

3 years of Experience in Design, develop, and maintain data integration workflows using Informatica IICS/IDMC (Cloud Data Integration (Azure), Cloud Application Integration, etc.).\\\\r\\\\nBuild and optimize ETL/ELT pipelines that ingest, transform, and load data into Databricks Lakehouse.\\\\r\\\\nProficiency in Linux/Python scripting.\\\\r\\\\nCollaborate with data architects, analysts, and business stakeholders to understand data requirements and deliver robust solutions.\\\\r\\\\nImplement best practices for data governance, metadata management, and data quality using Informatica tools.\\\\r\\\\nConfigure and manage connections between Informatica IICS/IDMC and Databricks, including secure authentication and data movement strategies.\\\\r\\\\nMonitor and troubleshoot data pipelines for performance, reliability, and scalability.\\\\r\\\\nAutomate data workflows and orchestrate jobs using Informatica’s scheduling and event-driven capabilities.\\\\r\\\\nDocument technical specifications, data flow diagrams, and operational procedures.\\\\r\\\\nExperience with Peta byte scale data ingestion, data migration.\\\\r\\\\nAbility to adopt various type of data formats and data sizes.

Completes work assignments by applying up-to-date knowledge in subject area to meet deadlines; following procedures and policies, and applying data and resources to support projects or initiatives; collaborating with others, often cross-functionally, to solve business problems; supporting the completion of priorities, deadlines, and expectations; communicating progress and information; identifying and recommending ways to address improvement opportunities when possible; and escalating issues or risks as appropriate. Practices self-development and promotes learning in others by proactively providing information, resources, advice, and expertise with coworkers and customers; building relationships with cross-functional stakeholders; influencing others through technical explanations and examples; adapting to competing demands and new responsibilities; listening and responding to, seeking, and addressing performance feedback; providing feedback to others and managers; creating and executing plans to capitalize on strengths and develop weaknesses; supporting team collaboration; and adapting to and learning from change, difficulties, and feedback. family, this position is responsible for leveraging DEVOPS, and both Waterfall and Agile practices, to design, develop, and deliver resilient, secure, multichannel, high-volume, high-transaction, on/off-premise, cloud-based solutions. Provides insight into recommendations for technical solutions that meet design and functional needs. Translates business requirements and functional specifications into physical program designs, code modules, stable application systems, and software solutions by partnering with Business Analysts and other team members to understand business needs and functional specifications. Assists in identification of specific interfaces, methods, parameters, procedures, and functions, as required, to support technical solutions. Leads systems\' incident support and troubleshooting for complex and noncomplex issues. Supports component integration testing (CIT) and user acceptance testing (UAT) for application initiatives by providing triage, attending test team meetings, keeping the QC up-to-date, performing fixes and unit testing, providing insight to testing teams in order to ensure the appropriate depth of test coverage, and supporting the development of proper documentation. B

Key Responsibilities

NA

Skill Requirements

Design, develop, and maintain data integration workflows using Informatica IDMC (Cloud Data Integration, Cloud Application Integration, etc.). Build and optimize ETL/ELT pipelines that ingest, transform, and load data into Databricks Lakehouse. Collaborate with data architects, analysts, and business stakeholders to understand data requirements and deliver robust solutions. Implement best practices for data governance, metadata management, and data quality using Informatica tools. Configure and manage connections between Informatica IDMC and Databricks, including secure authentication and data movement strategies. Monitor and troubleshoot data pipelines for performance, reliability, and scalability. Automate data workflows and orchestrate jobs using Informatica’s scheduling and event-driven capabilities. Document technical specifications, data flow diagrams, and operational procedures. Experience with Peta byte scale data ingestion, data migration. Ability to adopt various type of data formats and data sizes.

Other Requirements

Minimum three (3) years experience working on project(s) involving the implementation of solutions applying development life cycles (e.g., SDLC). Minimum one (1) year in a technical lead role with or without direct reports. Bachelor\'s degree in Computer Science, CIS, or related field and Minimum six (6) years experience in software development or a related field. Additional equivalent work experience may be substituted for the degree requirement..