Senior ETL Developer
Information Technology company
Information Technology company
Universal City, CA 91608
W-2 and C2C availableContractContract to Permanent721 views
Universal City, CA 91608
ContractContract to Permanent
Questions?
Click to chat now!
This posting has been closed

Around 6 to 8 years of experience with data warehousing and business intelligence.
• 6 to 8 years of experience in dealing with data architecture and modeling in Teradata, Informatica and SQL.
• • Hand's on working knowledge of Unix/Linux
• Building Complex SQL Queries in Teradata.
• Complex ETL program design coding with Teradata and Informatica
• Experience in Shell Scripting, Batch Scripting.
• Good communication (oral & written) and inter-personal skills
• Expert SQL and data analysis skill, ability to debug and fix data issue
• Experience of working with offshore team and managing and coordinating offshore team's work.
• Some working knowledge of big data and cloud technologies i.e Hadoop, and Azure.
• Certification in Informatica & Teradata preferred.
• Work closely with business teams to understand their business needs and participate in requirements gathering, while creating artifacts and seek business approval.
• Helping business define new requirements, Participating in End user meetings to derive and define the business requirement, propose cost effective solutions for data analytics and familiarize the team with the customer needs, specifications, design targets & techniques to support task performance and delivery.
• Propose good design & solutions and adherence to the best Design & Standard practices.
• Review & Propose industry best tools & technology for ever changing business rules and data set. Conduct Proof of Concepts (POC) with new tools & technologies to derive convincing benchmarks.
• Prepare the plan, design and document the architecture, High-Level Topology Design, Functional Design, and review the same with customer IT managers and provide detailed knowledge to the development team to familiarize them with customer requirements, specifications, design standards and techniques.
• Review code developed by other programmers, mentor, guide and monitor their work ensuring adherence to programming and documentation policies.
• Resolving critical problems to make sure the business continuity and to avoid revenue loss. Responsible for troubleshooting and resolving business critical bugs in production environment, testing of the changes and deployment of change to production.
• Work with functional business analysts to ensure that application programs are functioning as defined.
• Capture user-feedback/comments on the delivered systems and document it for the client and project manager’s review. Review all deliverables before final delivery to client for quality adherence.
• Responsible for preparing WSR and updating the status of key tasks.
• Representing the team in customer project meetings to update the project/task status and conducting daily status meetings to do task prioritization.
• Ensuring timely and defect-free solution delivery, responsible for SLA and project delivery as agreed with customer.

Skills
Skill Proficiency Years Experience Percent Used
ETL
3 - 6100%
SQL
Any100%
Data Analysis
Any75%
Data Warehousing
Any75%
ETL Developer
Any75%
Informatica
Any75%
Teradata
Any75%
Hadoop
Any50%
Agile Methodology
Any25%
Data Architecture
Any25%
Linux
Any25%
MS Azure
Any25%
Scrum
Any25%
UNIX
Any25%