Job Category: Contract Onsite
Job Type: Full Time
Job Location: Carey TX
Duration: 6 Months
- Lead ETL/ELT Architecture & Design – Design and architect enterprise-scale data integration solutions across cloud (Snowflake, GCP, Azure) and on-premises environments (Oracle, SQL Server, Teradata) using Informatica IDMC/IICS and PowerCenter, supporting multiple industry verticals.
- Cloud Data Migration Strategy – Spearhead complex data migration initiatives from on-premises databases to cloud platforms (Snowflake, BigQuery), ensuring data integrity, performance optimization, and minimal business disruption while achieving cost efficiency.
- Informatica Platform Governance & Administration – Oversee Informatica infrastructure including installation, upgrades, server migrations, secure agent deployment, and repository management; establish standards and best practices for enterprise-wide adoption.
- Production Support & Incident Management – Manage critical production incidents and escalations through structured management processes (ServiceNow); coordinate cross-functional stakeholder engagement to resolve issues and implement permanent solutions with minimal downtime.
- Data Warehouse & Integration Solutions – Develop and optimize data warehouse solutions implementing advanced techniques (Slowly Changing Dimensions, Change Data Capture, partition strategies) supporting real-time and batch processing requirements across diverse business domains (Retail, Pharma, Banking, Healthcare).
- Cloud SaaS Integration – Execute integration projects connecting enterprise SaaS platforms (Salesforce, Veeva CRM) with data warehouses and analytical systems,
enabling seamless data flow and business intelligence capabilities. - Performance Optimization & Tuning – Apply advanced optimization techniques including pushdown optimization, partitioning strategies, and CDC implementations to enhance ETL/ELT performance and reduce processing times for large-scale data operations.
- Cross-Platform Database Expertise – Leverage deep expertise across RDBMS systems (Oracle, SQL Server, Postgres, Teradata, DB2) with advanced SQL/PL/SQL
capabilities, DDL design, stored procedures, and indexing strategies to support diverse data requirements. - Automation & Infrastructure as Code – Implement infrastructure automation using shell scripting and scheduling tools (Control-M, Autosys, UC4, Cron) to ensure reliable job execution, monitoring, and operational excellence across distributed systems.
- Data Quality & Testing Governance – Establish data validation frameworks, develop comprehensive test strategies, and oversee System/Integration Testing to ensure data accuracy, completeness, and business requirement alignment across all ETL/ELT pipelines.
- Experience in Informatica (IDMC/IICS, Power Center, Power Exchange), Snowflake, GCP
- Experience in Various Data Engineering methods like Data Integration, Data Warehousing, Data Migration, application integration and Business Intelligence
- Experience on creation of Informatica cloud IICS services CDI, CDQ and CAI Services objects like Mappings, tasks, tasks flows, processes etc.
- Experience for Migration of data from Oracle, MS SQL Server to Cloud databases Snowflake, GBQ
- Experience in creating Data flows to extract/load into different Databases (Oracle, SQL Server, Snowflake, Postgres, GBQ, Teradata, and DB2)
- Experience writing query’s using in various RDBMS systems like Oracle (SQL, PL/SQL), Teradata, MS SQL Server, Postgres, including DDL creation, views, complex SQL constructs, stored procedures, indexing, Partitioning techniques
- Experience with DOS power shell scripting and UNIX Shell scripting
- Required experience on extracting data from GCS, AWS, Azure blob files into Data warehouse
- Strong experience in developing the Test plan, test scripts to perform data validation and Involved in System and Integration Testing
