Description:
Software Developer with Bachelor’s Degree in Computer Science, Computer Information Systems, Information Technology, or a combination of education and experience equating to the U.S. equivalent of a Bachelor’s degree in one of the aforementioned subjects.
Job Duties and Responsibilities:
- Work closely with cross-functional teams, comprising Data Engineers, Technical Architects, and Business Analysts to understand business requirements.
- Create/Update Data Model, Prepare Data Mapping and Technical Design documents as per business requirements, and obtain approval from technical architects and business analysts before proceeding with development.
- Implementation of Informatica PowerCenter, IDQ, and IICS mappings, tasks, rules, profiling, and unit testing from end to end, and provide ongoing support.
- Perform Administrative activities such as installing and configuring software, conducting system upgrades including patches, managing users and groups, and monitoring domain objects and logs using tools like Informatica, Stonebranch, and Qlik Replicate.
- Analyze and work on migration of Informatica PowerCenter objects to IICS. On Migration of objects make sure the functionality runs on on-premises and cloud-based systems remains same.
- Perform data profiling and collaborate with Data Stewards to identify data anomalies. Design and implement data quality rules and cleansing processes to correct and standardize data. Integrate data quality processes into ETL workflows and set up data quality monitoring alerts.
- Extract data from Flat files, XML/JSON files, Oracle using Informatica PowerCenter, Power Exchange, IICS and loaded into multiple target systems like PostgreSQL, Amazon S3, MS SQL Server.
- Integrate cloud-based and on-premises applications using IICS connectors and APIs. Develop Informatica Cloud solutions for cloud-based application integration, including data synchronization, data Replication, and mapping configuration.
- Create new connections and develop Full load and Change Data Capture (CDC) tasks utilizing Qlik Replicate to extract data from multiple source systems and load it into target systems such as Amazon S3, Oracle, and Postgres SQL.
- Perform code migration across environments like DEV, TEST, QA, and PROD, ensuring seamless deployment and consistency throughout the software development lifecycle.
- Create, schedule, and manage jobs using Stonebranch, ensuring timely execution and monitoring of critical tasks across the infrastructure.
- Perform upgrades for Stonebranch Controllers and Agents, as well as Qlik Replicate, ensuring minimal downtime and seamless transition.
- Implement Single Sign-On (SSO) for Stonebranch and Informatica PowerCenter, as well as establish a Disaster Recovery (DR) setup.
- Troubleshoot intricate issues, identify root causes and implement effective solutions to minimize downtime.
Work experience required for the position:
- At least 3+ years of ETL/Data Development experience in Informatica technology (Powercenter, IDQ, IDMC, IICS).
- Data migration experience with any cloud databases using IICS (Azure, AWS, GCP).
- Good working exposure in implementing end-to-end Data warehousing solutions using Informatica and Informatica cloud migration projects.
- Should have good understanding of IICS Data Integration service, Monitor, Application Integration, Administrator services.
- Should have working knowledge on IICS Mapping Tasks, Data Synchronization, Data Replication Tasks.
- Work closely with cross-functional teams, including data engineers, architects, and business analysts to understand business requirements.
- Translate business needs into technical design documents.
- Hands-on experience on Server Maintenance, Deployment, Connection creation, Access Management in Informatica Administrator.
- Install, configure Informatica software and Perform system upgrades, including patches.
- Troubleshooting, incident root-cause analysis with development teams and Work with vendor on issue resolution.
- Good knowledge of SQL - Oracle/SQL Server/Postgres SQL/AWS Redshift and Expertise in Linux shell scripting and/or python.
- Good understanding of Relational and dimensional Data modeling concepts and experience in Data Modeling tools (e.g. Erwin or SQL Data Modeler).
- Strong IDQ experience (specifically with IDQ 10.4.x and IDQ 10.5.x).
- Experience in performing data profiling, data mapping, data validation, data manipulation, data analysis.
- IDQ deployments & UAT/QA validations experience following SDLC process.
- Qlik replicate: Experience in creating new connections and replication tasks, debug and resolve performance issues, monitoring.
- Should have working experience in job scheduling using Autosys, Control-M, Stonebranch platforms or other 3rd parties.
- Experience working in Agile framework and hands on experience using Agile development process, e.g., JIRA.