ETL Developer with IICS, Informatica Power Center

Client: TCS Payroll: VARITE INDIA PVT LTD Note: Moved to direct TCS payroll after 3-6 months, subject to BGV report Clearance. Note: You can share the updated cv and UAN History or one payslip of the latest two years of exp to process the profile without any delay( Mail : Manpreet@gctechsoft.com). ( Verification of the UAN History or one payslip is to avoid fake profiles) Requirement: ETL Developer Exp: 4+ Years Location: Any TCS location in INDIA (WFO) Max Budget: 24LA Max NP: Serving within 30days ETL Developer Informatica PowerCenter | IDMC | AWS | GCP | Global Data Integration Platform | Engineering About the Role We are seeking a skilled ETL Developer with 4+ years of experience to join our Global Data Integration Engineering team. You will design, develop, and deliver robust ETL/ELT pipelines that power business-critical data flows across on-premise and cloud platforms. Working with Informatica PowerCenter and Informatica Data Management Cloud (IDMC), you will enable enterprise-wide data integration, data quality, and analytics initiatives across AWS and GCP environments. The ideal candidate combines strong Informatica expertise with modern cloud-native data engineering skills including hands-on experience with Google Cloud Composer for pipeline orchestration and a collaborative, architecture-minded approach. Key Responsibilities ETL Design & Development Design and develop scalable ETL/ELT pipelines using Informatica PowerCenter and IDMC (Cloud Data Integration, Mass Ingestion).Build complex mappings, workflows, and sessions handling large data volumes with optimal performance.Implement data transformations including Joiner, Aggregator, Lookup, Router, Expression, and custom SQL overrides.Design and develop cloud-native data pipelines on IDMC integrating AWS (S3, Redshift, Glue, RDS, Lambda) and GCP (BigQuery, Cloud Storage, Dataflow, Cloud SQL, Cloud Composer) services.Translate business and technical requirements into reliable, maintainable, and reusable integration components.Apply incremental load, CDC (Change Data Capture), and full-load strategies appropriate to source system constraints. Cloud & Platform Integration Build and configure IDMC connectors for AWS S3, Redshift, Google BigQuery, Cloud Storage, Salesforce, REST APIs, and relational databases.Design hybrid integration architectures spanning on-premise Informatica PowerCenter and cloud-based IDMC deployments.Work with cloud storage formats including Parquet, ORC, Avro, and Delta Lake for efficient data lake ingestion and transformation.Implement data pipelines adhering to cloud security best practices encryption, IAM roles, VPC configurations, and secrets management. Pipeline Orchestration with Google Cloud Composer Design, develop, and maintain DAGs (Directed Acyclic Graphs) in Google Cloud Composer (managed Apache Airflow) to orchestrate end-to-end ETL/ELT workflows across GCP and hybrid environments.Integrate Cloud Composer DAGs with Informatica IDMC tasks, PowerCenter workflows, BigQuery jobs, Dataflow pipelines, Cloud Functions, and GCS operations.Implement robust DAG design patterns including dynamic DAG generation, task dependencies, XComs for inter-task communication, branching logic, and SLA callbacks.Configure and use Airflow operators and hooks relevant to GCP services: BigQueryOperator, DataflowTemplateOperator, GCSToGCSOperator, and custom Python operators for Informatica API calls.Manage Cloud Composer environment configuration environment sizing, worker autoscaling, PyPI package dependencies, and variables via Secrets Manager. Data Quality, Governance & Tuning Utilise Informatica Data Quality (IDQ) and IDMC Data Quality assets to implement profiling, cleansing, standardisation, and validation rules.Partner with Data Governance teams to enforce metadata management, data lineage, and cataloguing using Informatica AXON or Enterprise Data Catalog (EDC).Tune Informatica sessions and mappings for throughput and resource efficiency partition strategies, pushdown optimisation, and cache tuning.Integrate pipelines and DAGs into CI/CD workflows using Git, Cloud Build, Jenkins, or equivalent tooling. Core Skills & Experience (Required) Informatica Architecture: Strong hands-on experience with Informatica PowerCenter Suite and IDMC (Informatica Intelligent Data Management Cloud) components.Google Cloud Composer & Airflow: Hands-on experience developing and maintaining Apache Airflow DAGs in Google Cloud Composer (v2/v3) for orchestrating ETL/ELT workflows using Python.Cloud Frameworks (AWS & GCP Client: TCS Payroll: VARITE INDIA PVT LTD Note: Moved to direct TCS payroll after 3-6 months, subject to BGV report Clearance. Note: You can share the updated cv and UAN History or one payslip of the latest two years of exp to process the profile without any delay( Mail : Manpreet@gctechsoft.com). ( Verification of the UAN History or one payslip is to avoid fake profiles) Requirement: ETL Developer Exp: 4+ Years Loca