Data Stage ETL Developer

Data Stage Etl Developer Location: Seattle, WA / St. Louis, MO / Plano, TX / Dallas, TX / Houston, TX Duration: Full Time Job Description:

• Design and develop Tera Data ETL jobs and data pipeline.
• Design, develop and support enterprise data warehouse solutions leveraging Teradata and Teradata tools and utilities.
• Extracting data from various data sources, transforming, and loading it into target systems.
• Ensuring data quality, integrity, and consistency across different systems.
• Optimizing ETL processes for performance, scalability and reliability.
• SQL proficiency (intermediate skill level minimum)
• Ability to manage Teradata SQL
• Troubleshooting and resolving data integration issues
• Solid skills with writing/translating SQL queries and SQL data validation.
• Performance tuning of SQL queries.
• Defining, managing, and monitoring job schedules, as well as troubleshooting issues within the Autosys environment
• Understanding and implementing job schedules, dependencies, and workflows within Autosys
• Analyzing and resolving issues with Autosys jobs and processes
• Jobs failures troubleshoot in AutoSys, failure can be Linux scripting, DataStage ETL, Teradata SQL.
• Part Loader which is ETL in DataStage

Roles & Responsibilities:

• Optimizing Database jobs for performance by collaborating with DBAs and implementing SQL coding and design changes within the job structure.
• Actively participated in troubleshooting and resolving issues related to data loading delays and database server outages, ensuring minimal disruption to data flow and system operations.
• Engaged in periodic reviews of job logs and performance metrics to identify trends, proactively addressing potential issues.
• Troubleshooting production issues through meticulous job log reviews, implementing necessary design changes via change management and adhering to the code promotion process.
• Contributed to the development and maintenance of documentation for troubleshooting procedures, best practices, and system configurations, facilitating knowledge sharing within the team and managing Change Requests
• Resolving data issues arising from load delays or database server downtimes, with a focus on ensuring customer satisfaction.
• Collaborated with stakeholders to understand business requirements, providing valuable insights and recommendations for optimizing data processing workflows.

If you are interested, please send me your updated resume ASAP with below details: Full Name: Current Location/Zip: Contact Number: E-Mail Id: Alternate Email Id: Visa/Work Permit Status: Current Rate/Salary: Expected Base Salary: Notice Period/Availability to Start: Skype ID: Willingness to relocate to job location: Any Relocation Concern (family/house/weather): Current/Previous Employer Name: Preferred Interview timings (Specify Time zone): Any other job opportunity in process & at which stage: Overall Experience Summary: LinkedIn URL: Looking forward for your response.. Thanks and Regards, Abhishek Singh Jconnect Infotech Inc. 168 Barclay Center Ste. 347, Cherry Hill, NJ 08034 Contact: View phone number on click.appcast.io Email: View email address on click.appcast.io. JConnect Infotech