SUMMARY:

• Over 10 Years of IT experience in SSIS and Informatica PowerCenter ETL & Informatica IDQ, Data Architect, Data Stage, Talend, Teradata developer, PostgreSQL (Greenplum), Tableau, Denodo, Spotfire, data warehousing, Data Integration, Oracle, Unix Scripts, Perl scripting, Python, Pl/SQL, Approx., Denodo, AWS (EC2, redshift, RDS, S3), Big data, Hadoop
• Knowledgeable in ETL and data warehousing concepts, SSIS and Informatica (7.1, 8.1, 9.1, 10), PostgreSQL (Greenplum) , Teradata V2R6, V2R12, Oracle 9i/10g, Talend Studio V5.6, Denodo & Spotfire, Dynamo DB(No - Sql), Data Integration, Data Architect
• Having Knowledge and basic coding in C, C++, Java, Db2.
• Having good knowledge in SDLC and Worked on Agile and waterfall methodologies.
• Experience in working on all phases of software Development life cycle (SDLC) - requirement gathering, test planning, analysis, design, implementation, and execution and closure phases.
• Having good experience in Informatica IDQ and Data Stage.
• Having knowledge in writing Perl scripting, Teradata developer, Microsoft Visual Studio, HTML, PHP.
• Having good knowledge in XML, Xpath, Xquery, DTD, XSLT and used XML files in Informatica as source and Target using XML parser and XML generator Transformation.
• Having basic knowledge in version control tools like GIT, TFS.
• Created business requirement docs and ETL architecture, technical specifications and processed documents for business practice and support. Worked on testing, preparing use cases, creating unit test cases and system integrated testing
• Having vast experience on UNIX by creating Unix Scripts. Experience in creating new Unix Scripts for end-end flow in SSIS and Informatica jobs.
• Experience Oracle Queries (SQL Developer, Toad), data warehousing, and Dimension data modeling (physical and logical), policies, rules or standards and optimizing SQL/oracle queries to increase performance.
• Having Knowledge in TDD (technical Design), HLD (high Level Design) and LLD (Low Level Design
• Having knowledge in Proficient in error handling, performance analysis and performance tuning of SSIS and Informatica ETL components and Teradata utilities, UNIX scripts and SQL scripts etc.
• Having good experience in SCD (type1 to 4) and CDC (Change data Capture)
• Experience in analyzing and creating existing Pl/SQL, PostgreSQL queries (in Greenplum) to load or Update data in new tables using Views or existing tables.
• A team player and used to work on multiple tasks at a time to meet deadlines and having good communication and interpersonal skills.
• Have strong analytical, trouble shooting, and problem-solving skills dedicated to maintain the high-quality standards and ability to work independently and Deploying code using Deploy.
• Experience in creating Jobs, Views (Base, Derived) and caches in Denodo and Experience in Spotfire Reports.
• Having knowledge in JIRA, Rally and confluence where tasks and sub tasks can be updated and which in turn stores all versions.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center, Informatica Power Exchange, Metadata Manager, Informatica Data Quality (IDQ), Informatica Data Explorer (IDE), MDM, SSIS, Salesforce, DataStage, etc.

Reporting Tools: Business Objects, QlikView, OBIEE, MicroStrategy, Oracle Analytics, etc.

Scheduling tools: Informatica Scheduler, CA Scheduler (Autosys), ESP, Maestro, Control-M.

Data Modeling: Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Physical, Logical Data Modeling, and ER Diagrams.

DB Tools: SQL Server Management Studio (2008), Oracle SQL Developer (3.0), Toad 11.6, SSIS, Microsoft SSRS (Oracle), DB2, Teradata, AQT v9 (Advanced query tool) (Oracle/Netezza), DB Artisan 9.0 (Sybase), SQL Browser (Oracle Sybase), VisioLanguages: C, C++, Java, .Net, Python, Perl Scripting, UNIX Shell Scripting, XSLT, PL/SQL, T-SQL.

Operating Systems: UNIX, Linux, Windows

PROFESSIONAL EXPERIENCE:

Confidential, GA

ETL Team Lead and Developer

Responsibilities:

• Worked on Informatica Power Center, SSIS, Data Stage, Cognos
• Designed ETL Mapping, workflows and monitor jobs in Informatica Repository, Packages in SSIS, Jobs in Data Stage using many transformations which includes data Extraction, Transform & Load, Data Integration, data quality.
• Uses Flat, XML Files, Oracle, Sql, Db2 tables as source in Informatica and Created UNIX shell scripts for SFTP and other event handlers.
• Created Data Models by using policies, rules or standards.
• Worked on how Data is stored, arranged, integrated, and put to use in data systems.
• Created User Reports, Graphs, Tables using SSRS & Spotfire
• Designed data modelling of the database and worked on back end Teradata, Oracle and Sql as Source or target Database.
• Having end- end SDLC phase from Requirement gathering, Development, QA Testing, Production Deployment and Support in Production
• Having knowledge in optimizing SQL queries to increase performance.
• Worked on pl/Sql queries, Perl/Unix/Python commands for Scripts to run.
• Worked on Agile and waterfall methodologies.
• Worked on AWS services by using Ec2, Redshift, S3 and Dynamo DB.
• For few interfaces having huge data, Hadoop is used to handle Big data by splitting data into small chunks as blocks.
• DAC is sued to schedule and monitor Jobs.

Tools: Informatica 9.1, 9.5, 10.0(ETL), SQL developer, Data Stage, Cognos, Toad, SQL server, WinSCP, Putty, Command prompt, Hadoop, AWS services, SSIS, SSRS, DAC.

Confidential, GA

ETL Team Lead and Developer

Responsibilities:

• Worked on data profiling using SQL Queries in Db2 and Idq.
• Created Data Models by using policies, rules or standards.
• Worked on how Data is stored, arranged, integrated, and put to use in data systems.
• Designed ETL Mapping, workflows and monitor jobs in Informatica Repository and Profiles, and Score cards in IDQ in Development phase and in data Stage using different Transformations and Developed, Tested and deployed to production.
• Uses Flat, XML Files, Oracle, Sql, Db2 tables as source in Informatica and Created UNIX shell scripts for SFTP and other event handlers.
• Create Reports in Cognos
• Direct interaction with client.
• Designed data modelling of the database. worked on Back end Teradata, DB2 And ORACLE Database.
• Worked on Perl/Unix/Python scripting using commands.
• Worked on Agile and waterfall methodologies.
• Having end- end SDLC phase from Requirement gathering, Development, QA Testing, Production Deployment and Support in Production
• Having knowledge in optimizing SQL queries to increase performance.
• Worked on AWS services by using Ec2, Redshift, S3 and Dynamo DB.
• Uses XML Files as source in Informatica and having basics on Xpath, Xquery and other commands.
• For one of interface having huge data, Hadoop is used to handle Big data by splitting data into small chunks as blocks.
• DAC is sued to schedule Jobs.

Tools: Informatica 9.1, 9.5, 10.0(ETL), IDQ, Data Stage, Data Stage, SQL developer, Toad, SQL server, WinSCP, PGAdmin (Green Plum) Putty, Command prompt, Hadoop, AWS services, SSIS, DAC, Approx

Confidential, CT

ETL Team Lead and Developer

Responsibilities:

• Analyzed specifications provided by the clients
• Responsible for solutions design and development
• Designed data modelling of the target database.
• Created Data Models by using policies, rules or standards.
• Worked on how Data is stored, arranged, integrated, and put to use in data systems.
• Created Jobs in Data Stage, Cognos using many transformations which includes data Extraction, Transform & Load, Data Integration and Tested and deployed to production
• Provided data architecture and analysis for analytics and forecast and Directed reporting team interaction
• Created ETL mapping documentation and unit test plans and system integration test plans.
• Uses SCD type 1 and Type 2 and CDC logic in SSIS and informatica
• Developed ETL mappings and workflows in both SSIS and Informatica and monitored the jobs in production
• Uses Flat, XML Files, Oracle, Sql, Db2 tables as source in Informatica and Created UNIX shell scripts for SFTP and other event handlers.
• Employed Greenplum DB and Informatica ETL for warehouse.
• Worked on Talend After project migration from SSIS and Informatica to Talend and in this process, we developed all mappings in Talend and deployments to QA and prod migrations
• In talend, we created new mappings using transformations using File and Oracle Databases as Sources and targets.
• Having end- end SDLC phase from Requirement gathering, Development, QA Testing, Production Deployment and Support in Production.
• Worked on Teradata as backend. In Teradata, we used to connect to date and audit tables.
• Create data model and prepare DMS.
• Created functions to load data from source tables into target tables as per DMS in Greenplum.
• Analyze, debug the functions in case of any issues in Greenplum.
• Create and Monitor Approx Jobs for Informatica, Denodo and Spotfire Jobs.
• Create Denodo Jobs for GP Database objects which helps to create Spotfire jobs.
• Worked on Perl, Python, scripting using commands
• Worked on Agile and waterfall methodologies.
• Having good knowledge in XML and used XML files in Informatica as source and Target using XML parser and XML generator Transformation.
• Worked on AWS services by using S3.
• For one of interface having huge data, Hadoop is used to handle Big data by splitting data into small chunks as blocks.
• DAC is sued to schedule Jobs.

Tools: Informatica 9.1, 9.5, 10.0(ETL), IDQ, SQL developer, Data Stage, Toad, SQL server, WinSCP, PGAdmin (Green Plum) Putty, Command prompt, Hadoop, AWS services, SSIS, DAC, Approx.

Confidential, CT

ETL Senior software Engineering

Responsibilities:

• I am one of key resource of Project at ETL side and Reporting Side.
• Developed ETL mappings, workflows in both SSIS and Informatica and monitored the jobs in production.
• Created Data Models by using policies, rules or standards.
• Worked on how Data is stored, arranged, integrated, and put to use in data systems.
• Created Jobs in Data Stage using many transformations which includes data Extraction, Transform & Load, Data Integration and Tested and deployed to production.
• Uses Flat, XML Files, Oracle, Sql, Db2 tables as source in Informatica and Created UNIX shell scripts for SFTP and other event handlers.
• Worked on ETL design documents and end-end coding along with testing for various load strategies with Informatica or Teradata load utilities
• Managed teams with regular heads-up calls and idea hours, managed a team of eleven from the various vendor-technologies, testing and front end
• Evaluated performance impact and enhancements for Informatica ETL or Teradata SQL
• Interacted with the front-end developers and implemented DAL layers by providing views, procedures, macros and queries
• Worked on Agile and waterfall methodologies.
• Uses SCD type 1 and Type 2 and CDC logic in SSIS and informatica
• Having good knowledge in XML and used XML files in Informatica as source and Target using XML parser and XML generator Transformation.
• Having end- end SDLC phase from Requirement gathering, Development, QA Testing, Production Deployment and Support in Production

Tools: Informatica 9.1, 9.5, 10.0(ETL), SQL developer, Data Stage, Toad, SQL server, WinSCP, Putty, Command prompt,

Confidential

ETL software Engineering

Responsibilities:

• Communicated with Business regarding the requirements
• As a crucial team member worked on the Requirement Analysis, test planning, design, execution.
• Always help support team on any issues.
• Uses SCD type 1 and Type 2 and CDC logic in SSIS and informatica.
• Created Data Models by using policies, rules or standards.
• Worked on how Data is stored, arranged, integrated, and put to use in data systems
• Having end- end SDLC phase from Requirement gathering, Development, QA Testing, Production Deployment and Support in Production.

Confidential

ETL software Engineering

Responsibilities:

• Communicated with Business regarding the requirements & Key resource of Project at ETL and Reporting Side.
• Created ETL Flows with managed the ETL teams of six, creating ETL and monitoring performance.
• Developed ETL mappings and workflows in both SSIS and Informatica and monitored the jobs in production
• Having end- end SDLC phase from Requirement gathering, Development, QA Testing, Production Deployment and Support in Production