Business Intelligence Analyst

POSITION OVERVIEW : Technical Analyst POSITION GENERAL DUTIES AND TASKS : Informatica Technical Analyst We are seeking a highly skilled and experienced Informatica Lead to join our IT team. The ideal candidate will lead a team of ETL developers and oversee the design, development, and implementation of ETL solutions using Informatica PowerCenter and Cloud Data Integration. This role requires expertise in data integration, leadership skills, and the ability to work in a dynamic environment to deliver robust data solutions for business needs.

Responsibilities:

Primary Skillset - Informatica, Data Mapping, Data modelling, , Scripting language, SQL, TOAD, Oracle.

• S2T Mapping Documenting the business, functional, mapping specs
• Complex SQL, Exposure in working Hybrid/Agile Methodology
• Attend Requirements/BRD/Brainstorming sessions to understand Business requirements/changes
• Design technical documents like STM (Source to Target Mapping), EMD (Extract mapping document), TRD (Technical Requirement Document) to develop Business Requirements/changes
• Conduct technical documents hand-off session with Developers and QAs
• Review Test plan and Test scenarios created by QA team and Sign-off
• Review Test Results created by QA Team and review comments for any additional or regression TCs to be covered
• Monitoring Production deployment and conduct smoke test in production for recent deployments
• ETL Development and Maintenance: Lead the design, development, and maintenance of ETL workflows and mappings using Informatica PowerCenter and Cloud Data Integration
• Ensure the reliability, scalability, and performance of ETL solutions to meet business requirements
• Optimize ETL processes for data integration, transformation, and loading into data warehouses and other target systems
• Solution Architecture and Implementation:
• Collaborate with architects and business stakeholders to define ETL solutions and data integration strategies
• Develop and implement best practices for ETL design and development
• Ensure seamless integration with on-premises and cloud-based data platforms
• Data Governance and Quality: Establish and enforce data quality standards and validation processes
• Implement data governance and compliance policies to ensure data integrity and security
• Perform root cause analysis and resolve data issues proactively
• Team Leadership: Manage, mentor, and provide technical guidance to a team of ETL developers
• Delegate tasks effectively and ensure timely delivery of projects and milestones
• Conduct regular code reviews and performance evaluations for team members
• Automation and Optimization: Develop scripts and frameworks to automate repetitive ETL tasks
• Implement performance tuning for ETL pipelines and database queries
• Explore opportunities to improve efficiency and streamline workflows
• Collaboration and Stakeholder Engagement: Work closely with business analysts, data scientists, and application developers to understand data requirements and deliver solutions
• Communicate project updates, challenges, and solutions to stakeholders effectively
• Act as the primary point of contact for Informatica-related projects and initiatives

Required Skills:

• Experience in ETL development and data integration
• Proven experience with Informatica PowerCenter, Informatica Cloud Data Integration, and large-scale ETL implementations
• Experience in integrating data from various sources such as databases, flat files, and APIs
• Preferred Skills: Strong expertise in Informatica PowerCenter, Informatica Cloud, and ETL frameworks
• Proficiency in SQL, PL/SQL, and performance optimization techniques
• Knowledge of cloud platforms like AWS, Azure, or Google Cloud
• Familiarity with big data tools such as Hive, Spark, or Snowflake is a plus
• Strong understanding of data modeling concepts and relational database systems