Srikanth

13+ years of IT experience in Analysis, Design, Development, Implementation and Support on various applications. Extensive experience in Data warehousing applications using ETL technologies (Abinitio, Informatica) and Unix/Linux operating system. Good understanding in preparing the business requirements and ETL specs for designing mappings.

Experience in interaction with the Business Analysts, identifying the needs, requirements of the system and involved in requirement study of the system. Expertise in demonstrate solutions by developing technical documentation, high and low level design documents. Understanding the complexity of the graphs and to design within the estimated time.

Expertise in debugging, and running the graphs in UNIX environment. Good in developing value added services like early warning alert systems to achieve high availability of the systems. Extensively participated in implementation activities.

Responsible for maintaining complex systems and its SLA's. Track and Progress on Problem Management, Incident Management, Change Management, Knowledge Management and Release Management. Good in providing first response to reported production incidents followed by resolution or escalation as necessary and status reporting.

Providing production support and coordinating with multiple dependent teams to troubleshoot and fix application issues. Conduct meetings with Product Owners at regular intervals and provide updates on pending application issues/solutions implementation. Deep Dive into root causes of any incident and implement permanent resolution to avoid reoccurrence.

Coordinate between onsite and offshore teams. Assisting the team to ensure that the tasks are delivered on schedule. Make sure to deliver customized reports on daily, weekly, monthly and quarterly basis.

Obtain

Customer signoff on hot fixes deployed in the systems. Team Player with the ability to communicate effectively at all levels of the development process. Requirement gathering and participate in Analysis, Problem Definition, Understanding the Design and Solution Development.

Good knowledge in components, parameterization, performance tuning with Ab Initio's GDE 3.x, Co>OP 3.x, Metadata Hub and the EME repository. Expertise in document ETL business requirements specification. Thorough knowledge on Data warehouse concepts like Star Schema, Snow Flake, Dimension and Fact tables.

Having

Good communication and interpersonal skills, well spoken, teamwork, flexible, self-direct and energetic person.

Senior Data Engineer at CGI (2025-01 – Present)

EDH (Enterprise Data Hub) and Enterprise Counterparty Hub are target-state modernization initiatives for Fannie Mae, rewriting existing Ab Initio ETL logic into AWS Glue based pipelines, with Amazon Redshift and AWS Glue Catalog tables serving as the target-state data platform. EDH is an AWS-based data ingestion and risk-analytics platform that processes counterparty (CTRPTY), financial (FNCL), and party-master data from multiple upstream sources (MB, CBSB, CU, CCU), supporting both daily/batch loads and incremental/full-refresh update cycles.

• Re-engineered and rewrote existing Ab Initio ETL graphs into AWS Glue (PySpark) jobs as part of the target-state modernization for EDH and Enterprise Counterparty Hub.
• Designed and built target-state data models using Amazon Redshift tables and AWS Glue Catalog tables.
• Used Terraform to build and deploy infrastructure as code, including Redshift table creation, Glue Catalog database/table definitions, and Glue job deployments.
• Established Redshift Datashare connections to read data directly from upstream source Redshift clusters, removing the need for duplicate data copies and reducing pipeline latency.
• Worked with upstream data teams to define and validate datashare-based data contracts for consuming their Redshift tables.
• Performed data validation between legacy Ab Initio-generated outputs and the new AWS Glue/Redshift target-state outputs to ensure parity during the migration.
• Collaborated with Data Modeling and BI teams to align the Glue Catalog and Redshift schema design with downstream reporting and analytics needs.
• Provided root cause analysis and resolution support for issues raised during QA/UAT/PROD phases of the target-state build.
• Designed and maintained AWS Glue ETL pipelines to ingest and transform party-master, counterparty, financial, and MB/CBSB/CU/CCU upstream source data into the Enterprise Data Hub, supporting both daily/batch and on-demand full-refresh loads.
• Built serverless orchestration using AWS Lambda, Step Functions, and SNS for workflow execution and status tracking, upstream data validation, batch-job submission and monitoring, and automated failure notifications.
• Developed and maintained Ab Initio update graphs for complex risk-grade calculations, including PFE-weighted relative IRR scoring.
• Built and optimized complex Oracle SQL for data calculations and processing, ensuring data accuracy across incremental and full-refresh update cycles.
• Managed Terraform infrastructure as code for Glue tables and Glue Catalog definitions, and owned GitLab CI/CD pipelines deploying across dev, dev2/3, ACPT, and prod environments.
• Managed database schema versioning and migrations using Flyway, and built ECR/Docker container images for Glue and Lambda deployments.
• Supported a Flask-based backend used by business teams for data curation and review workflows.

Senior ETL Developer at CGI (2019-08 – 2024-12)

Risknet is Fannie Mae's enterprise-wide counterparty risk management system. The goal of the risknet is to provide the most accurate and timely information available to effectively monitor and evaluate counterparty risk exposure.

• Documents all technical and system specifications requirement for all existing ETL processes and putting it into a new design by maintaining a do-no-harm approach to existing downstream consumers.
• Perform a code development to build complex solutions using Abinitio graphs.
• Serve as team liaison with business partners to analyze the impact of new requirements and business process change on existing system and process.
• Generic architecture for all application process to utilize maximum reusability of code.
• Led the migration (2023–2024) of 50+ legacy Ab Initio ETL graphs and the Risknet platform from on-premise Unix servers to AWS Cloud (S3/Redshift), reducing processing time by 40%.
• Performed import and export of data to and from AWS S3.
• Build the code and migration to QA environment and matching the test harness of target load ready files between existing system and load ready file generated in new environment.
• Perform root cause analysis on issues raised during QA/UAT/PROD phases and providing resolutions/validation for all issues and perform routine support to all ETL applications under warranty phase.

Senior ETL Developer at SSATECH INC (2019-05 – 2019-08)

To reduce JPMC's dependency and operational risk on existing 3rd party data providers and make alternate providers available for use. The Third party data providers send data on chase customers or prospects only, in batch and real-time, depending on use case. An ingestion component maps the data to a common format, executes data quality & validation rules and captures the lineage.

Sends results to a data warehouse for analytics and catches it. CUBE provides a platform to obtain Third party data for internal consumption for business process & applications.

• Documents all technical and system specifications requirement for all existing ETL processes and putting it into a new design by maintaining a do-no-harm approach to existing

Bachelor of Technology in Information Technology – Jawaharlal Nehru technology & University