Scd2 implementation in datastage parallel jobs

SUDEEP REDDY 781-499-2656 Sudeep8621@gmail.com https://www.linkedin.com/in/sudeep-reddy PROFILE SUMMARY Data Stage developer having 5 years of experience and broad skill sets in ETL programming using Web Sphere Data Stage (parallel version)8.1v/11.5 v and Strong background in Data Warehousing, Star Schema, snowflake schema and ETL jobs. Good logical ability and systematic approach to problem solving analysis, Integration Management solution design and strong debugging skills. Able to quickly learn and understand business domain and behave to deliver business value on a consistent basis. Excellent team player with strong written, communication and analytical skills. Capable of working under high stress environment with resource constraints. CORE COMPETENCIES • • • • • Datastage Designer Linux and shell scripting Experience Design & Develop ETL Jobs Business Analysis Data Stage/SQL. • • • • Cloud database (snowflake) Project Planning and Execution PL/SQL Technical Support and Service • • Leadership and Development Interpersonal Relations PROFESSIONAL SKILLS • • • • • • • • • • • Having strong knowledge in extracting data from legacy systems to stage and then Cleanse, Process and Loading into Data Marts and Data Warehouse. Developed parallel jobs using different processing stages like Transformer, Aggregator, Lookup, Join, Sort, Copy, Merge, Funnel, CDC, Change Apply, Filter, Datasets, Change Data Capture, Row Generator and many other stages in accomplishing the ETL Coding. Experienced in integration of various data sources ( SQL Server, PL/SQL, Oracle, PostgreSQL , GreenPlum , MySQL) into data staging area. Experienced in creating data warehouse documentation including, but not limited to requirements, technical specifications, and source to target mappings. Expertise in UNIX shell scripts using K-shell for the automation of processes and scheduling the Data Stage jobs . Experienced in Database programming for Data Warehouses (Schemas), proficient in dimensional modeling (Star Schema modeling, and Snowflake modeling). Hands on experience in Tuning Jobs, bug identifying and resolve performance in Parallel Jobs in Data Stage. Maintaining and running regular database backup’s Troubleshooting Datastage jobs (ETL) Developed the Data Modeling in snowflake Working experience in various domains like Retail sales, insurance. SUDEEP REDDY TECHNICAL SKILLS ETL Tools: IBM Data stage 11.5 Databases: SQL Server 2008, Oracle 11g/10g/9i, Greenplum Database Tools: TOAD, SQL Plus, SQL Developer Languages: SQL, Transact SQL (T-SQL), PL/SQL, UNIX Shell Scripts, C, C++, HTML, XML Load Utilities: SQL Loader Scheduling Tools: Control-M, Autosys, Tws BI Reporting Tools: Tableau Operating Systems: UNIX, Linux, Windows 9x/2000/NT/XP, 2003/2008 Windows Server PROFESSIONAL EXPERIENCE Sr Datastage Developer Feb 2018 – Till Date Stanley Black and Decker - New Britain , CT Our Client large customers continually ask them how much their doors cost them and when they should be serviced or replaced. This process is a time consuming manual effort today that requires automated reporting capabilities. Duties and Accomplishments: ▪ Used various sourced and designed and developed jobs in order to facilitate the integration process of the expenditures. ▪ Analyzed reports made by business user to extract data to effectively integrate expenditures from various sources. ▪ Evaluated the Data extraction from source to confirm for data irregularities and classify corrupt data to apply suitable transformation in the mappings in the jobs.