As a Software Engineer, you will:
- Analyze business and functional requirements to design and implement scalable data integration solutions.
- Understand and interpret High-Level Design (HLD) documents and convert them into detailed Low-Level Design (LLD).
- Develop robust, reusable, and optimized Informatica mappings, sessions, and workflows.
- Conduct peer code reviews and suggest improvements for reliability and performance.
- Prepare and execute comprehensive unit test cases and support system/integration testing.
- Maintain detailed technical documentation, including LLDs, data flow diagrams, and test cases.
- Build data pipelines and transformation logic in Snowflake, ensuring performance and scalability.
- Develop and manage Unix shell scripts for automation, scheduling, and monitoring of ETL jobs.
- Collaborate with cross-functional teams to support UAT, deployments, and production issues.
Requirements:
You are a fit for this position if your background includes:
- 2-4 years of strong hands-on experience with Informatica PowerCenter.
- Proficiency in developing and optimizing ETL mappings, workflows, and sessions.
- Solid experience with performance tuning techniques and best practices in ETL processes.
- Hands-on experience with Snowflake for data loading, SQL transformations, and optimization.
- Strong skills in Unix/Linux scripting for job automation.
- Experience in converting HLDs into LLDs and defining unit test cases.
- Knowledge of data warehousing concepts, data modeling, and data quality frameworks.
Good to Have:
- Knowledge of Salesforce data model and integration (via Informatica or API-based solutions).
- Exposure to AWS cloud services like S3, Glue, Redshift, Lambda, etc.
- Familiarity with relational databases such as SQL Server and PostgreSQL.
- Experience with job schedulers like Control-M, ESP, or equivalent.
- Agile methodology experience and tools such as JIRA, Confluence, and Git.
- Knowledge of DBT (Data Build Tool) for data transformation and orchestration.
- Experience with Python scripting for data manipulation, automation, or integration tasks.
