Informatica Lead

Role & responsibilities

Conducts or oversees business-specific projects by applying deep expertise in subject area; promoting adherence to all procedures and policies; developing work plans to meet business priorities and deadlines; determining and carrying out processes and methodologies;
coordinating and delegating resources to accomplish organizational goals; partnering internally and externally to make effective business decisions; solving complex problems; escalating issues or risks, as appropriate; monitoring progress and results; recognizing and capitalizing on improvement opportunities; evaluating recommendations made; and influencing the completion of project tasks by others. Practices self-leadership and promotes learning in others by building relationships with cross-functional stakeholders; communicating information and providing advice to drive projects forward; influencing team members within assigned unit; listening and responding to, seeking, and addressing performance feedback; adapting to competing demands and new responsibilities; providing feedback to others, including upward feedback to leadership and mentoring junior team members; creating and executing plans to capitalize on strengths and improve opportunity areas; and adapting to and learning from change, difficulties, and feedback. As part of the IT Engineering job 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. Ensures appropriate translation of 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. Serves as an expert for innovative technical solutions that meet design and functional needs. Facilitates and serves as a technical expert for project teams throughout the release schedule of business and enterprise software solutions. Builds and maintains trusting relationships with internal customers, third party vendors, and senior management to ensure the alignment, buy-in, and support of diverse project stakeholders. Recommends complex technical solutions that meet design and functional needs. Collaborates with architects and/or software consultants to ensure functional specifications are converted into flexible, scalable, and maintainable solution designs. Provides expertise and guidance to team members for systems incident responses for complex issues. Provides implementation and postimplementation triage and support of business software solutions by programming and/or configuring enhancements to new or packagedbased systems and applications. Reviews and validates technical specifications and documentation. Identifies specific interfaces, methods, parameters, procedures, and functions to support technical solutions while incorporating architectural designs. 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. Leads systems incident support and troubleshooting for complex and noncomplex issues. Identifies specific interfaces, methods, parameters, procedures, and functions, as required, to support technical solutions serving as an escalation point for complex or unresolved issues related to requirements translation. Develops and validates complex testing scenarios to identify application errors and ensure software solutions meet functional specifications. Participates in all software development lifecycle phases by applying comprehensive understanding of company methodology, policies, standards, and internal and external controls. Develops, configures, or modifies basic to moderately complex integrated business and/or enterprise application solutions within various computing environments by designing and coding component-based applications using programming languages. Provides consultation to help ensure new and existing software solutions are developed with insight into industry best practices, strategies, and architectures. Builds partnerships with IT teams and vendors to ensure written code adheres to company architectural standards, design patterns, and technical specifications. Leads the development, validation, and execution of testing scenarios to identify application errors and ensure software solutions meet functional specifications. Leads, mentors, and trains other technical resources to develop software applications.

Preferred candidate profile

5 years of Experience in Design, develop, and maintain data integration workflows using Informatica IDMC (Cloud Data Integration (Azure), Cloud Application Integration, etc.).
Build and optimize ETL/ELT pipelines that ingest, transform, and load data into Databricks Lakehouse. Proficiency in Linux/Python scripting 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 Informaticas 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.