ETL DeveloperOverview: Perform production support, development, and design activities at client site for ETL.Responsibilities:Interact with stakeholders for requirementsAssist on support and enhancements modulesQuery optimizationReview functional requirements and technical specifications and document them as neededRequirements:Must have around 8+ years of experience on complex transformation and loading of high-volume data in terabytes.
Experience in Datastage with Teradata.
Experienced in SQL, PL/SQL. Knowledge of production support and development. Excellent communication skills. Excellent in datawarehousing concept. Strong DW concepts. Strong analysis skills. Have good communication skills, interpersonal relations, hard working and result oriented as an individual. Strong skills in all aspects of SQL development (triggers, stored procedures, views, etc.) and implementation.
Experience writing large, complex stored procedure involving temp tables, cursors, and multiple nested procedure calls.
Experience in performance tuning, strong performance tuning knowledge in SQL and ability to interpret plans, identify bottlenecks in queries and remediate them.
Experience with ETL development (Datastage) and Data Integration. Strong knowledge of database technologies and principles, including data modeling, data mapping etc. Strong experience with data analysis, troubleshooting data issue. Fluent in relational database concepts and flat file processing concepts. Must be knowledgeable in software development lifecycles/methodologies. Work with customers to understand reporting and system integration requirements. Coordination of offshore work. Should have experience in development/production support and maintenance. Should have experience in designing the data mart and datawarehouse. Should demonstrate excellence in understanding the existing data models and ability to redesign them as per changing business needs. Should demonstrate excellent written and verbal communication skills. Should have experience in dealing with business users and Sr. Management. A strong knowledge of business intelligence design concepts, with a concentration in dimensional modeling in RDBMS. A strong working knowledge of SQL. Should have worked on projects involving medium – large data warehouses.Mandatory Skills: Production Support Experience, Strong Experience in Teradata, Application Development Skills, Requirements Gathering, Data Modeling, System Design