Sr Informatica Developer

Experience: ++ years

Location: Pune

· Design, develop and implement robust and extensible ETL solutions to support data warehouse integrations and transformations using CDI/CAI services on IICS platform, UNIX/PowerShell.

· Partner with business and subject matter experts to identify, document & design based on the business requirements, functional specs and translate them into appropriate technical solutions.

· Understand the Software Development Lifecycle and ability to apply the SDLC to existing and future development initiatives.

· Responsible for estimating, planning, and managing the user stories, tasks and reports on Agile Projects.

· Performance tuning and optimizations of ETL Jobs, SQL Queries and Scripts.

· Configure and maintain scheduled ETL jobs.

· Manage and Implement CICD for Informatica Intelligent Cloud Services ETL pipelines.

· Develop advanced PLSQL Procedures, Functions and SQL jobs.

· Support exploratory data analysis, statistical analysis and predictive analytics.

· Develop data integrations between internal and external/third party sources.

· Support production issues and maintain existing data systems by researching and troubleshooting any issues/problems in a timely manner.

· Develop technical solutions using Data Bricks, Snowflake or Azure Synapse architecture.

· Participate in the development of corporate-wide strategies, processes, and standards for data architecture, storage and reporting.

· Proactive, great attention to detail, results-oriented problem solver.

Decision Making

· This position needs to possess the ability to act quickly with independent thinking and sound judgment.

· Works under the direction of data architect or manager of data analytics.

· Ability to make required and immediate decisions on his/her own and escalate complex issues as needed.

Additional Job Requirements

· Bachelor’s Degree or higher in Engineering, Technology or related field experience required.

· ++ years of experience with any ETL Integration tools like Informatica Power center, IICS, Talend, etc.,

· 4+ years of experience in CDI/CAI Integration Services in IDMC platform.

· 8+ years of experience working with SQL queries.

· In depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.

· 5+ years’ experience with design, build, test, and maintain data integrations for data marts and data warehouses.

· 4+ years’ experience with Azure Cloud platform and services.

· 2+ years’ experience working with Snowflake, Data Bricks or Azure Synapse data platforms.

· Ability to effectively prioritize and execute tasks in a high-pressure environment and react to project adjustments and alterations promptly and efficiently.

· Demonstrated experience with various BI technologies.

· Proven abilities to take initiative and be innovative.

· Analytical mind with a problem-solving aptitude

· Excellent verbal and written communication skills

· Experience managing all phases of the project life cycle, including running project prioritization meetings, post-installation project post-mortem meetings and a proven track record of managing multiple tasks and meeting deadlines.

· Collaboration with both onshore and offshore development teams

· Preferred skills:

Exposure to Qlik Sense, data mining, Dynamics CRM, Salesforce