Open to opportunities

Sai Lakshmi Tankala

@sailakshmitankala

Message

Experienced Data Engineer with expertise in ETL and data modeling.

Singapore

Message

What I'm looking for

I am seeking a role that fosters innovation and offers opportunities for professional growth in data engineering.

I am a seasoned Data Engineer with over 11 years of IT experience, specializing in data warehousing and business intelligence. My journey has equipped me with a robust skill set in designing, developing, and implementing data models for enterprise-level applications. I have a proven track record of leading projects using both Agile and waterfall methodologies, successfully managing teams of up to 15 members.

Throughout my career, I have honed my expertise in various ETL tools, including Informatica PowerCenter, IDMC, and DataStage. My hands-on experience spans across multiple data sources such as Oracle, DB2, and AWS Redshift, where I have excelled in data extraction, transformation, and loading processes. I am passionate about optimizing ETL processes and ensuring data accuracy, which has led to significant improvements in project deliverables and client satisfaction.

Experience

Work history, roles, and key accomplishments

Current

Senior Application Developer/Cloud Integration Developer

Current

Freddie Mac

Apr 2024 - Present (1 year 3 months)

Processed CSN-related information using Informatica IICS and PowerCenter 10x, involving business data analysis, profiling, and medical data simulation. Developed and migrated Informatica jobs to IDMC with AWS Redshift as the target database, and created BYOL scripts for AWS Glue and DynamoDB.

Informatica Informatica PowerCenter 10.X AWS RedShift Python SQL REST APIs SOAP Jenkins

Domain Specialist / Senior Data Engineer

Tan Tock Seng Hospital

Aug 2021 - Jan 2024 (2 years 5 months)

Processed HL7/FHIR messages using Informatica IICS and PowerCenter 10x, including business data analysis, profiling, and medical data simulation. Developed and migrated Informatica jobs to IDMC with AWS Redshift and GCP as target databases, and implemented MDM for data cleansing and match/merge checks.

Informatica Informatica PowerCenter 10.X MDM AWS RedShift GCP Snowflake PostgreSQL Python REST APIs SOAP Jenkins

Data Engineer

Government of Singapore Investment Corporation and Accenture

Feb 2020 - Jul 2021 (1 year 5 months)

Gathered project requirements from various custodians and created ETL mappings and sessions to load data warehouses in MS SQL using Informatica. Developed design specifications and performed quality assurance for integrating third-party data into a proprietary data warehouse. Migrated jobs from Informatica PowerCenter to Informatica BDM, pointing to Hive file systems.

Informatica PowerCenter 9x SQL Informatica Hadoop Hive DataStage Oracle MDM

Senior Systems Analyst

Integrated Health Information Systems (SYNAPXE)

Jan 2018 - Jan 2020 (2 years)

Developed ETL designs and tools to extract data from DB2, Oracle, and XML databases, populating database tables for OBIEE reports. Led offshore developers, providing assistance in understanding business requirements and data integration components. Performed build, unit, system, and user acceptance testing, and designed documented report processing logic.

Informatica PowerCenter 9.5.1 AWS Glue Teradata Oracle Snowflake Autosys Unix Jenkins

Technology Specialist

Wells Fargo Solutions Pvt Ltd.

Feb 2018 - Dec 2018 (10 months)

Performed data analysis and profiling for WCDIR-WHOLESALE CREDIT DATA INFRASTRUCTURE. Modified and maintained existing mappings, sessions, and workflows, and was solely responsible for deploying activities and resolving errors during the warranty period. Developed shell scripts for post-sprint release changes and optimized complex ETL jobs.

Informatica PowerCenter 9.5 SQL SSIS Unix Teradata DataStage Autosys

Senior Systems Engineer

PWC and Infosys Ltd.

May 2014 - Jan 2018 (3 years 8 months)

Involved in the complete life cycle of designing, developing, testing, and deploying data marts, including aggregating, manipulating, and analyzing large datasets for recurring reporting. Created ETL mappings and sessions to load target MS-SQL Server, MIDA, and CCOE databases from Oracle and flat files. Automated Informatica jobs using UNIX shell scripting and scheduled them through TWS.