Scd2 implementation in datastage parallel jobs

Need to change format of existing Resume Need to change format of existing Resume

Need to change format of existing Resume 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.