Job Description
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
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
💡 Quick Summary
Seeking a career-building opportunity? The Sr| Informatica Developer position is now open for candidates interested in the Software Developer Jobs sector. This role in Pune offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Software Developer Jobs is a plus.