ETL Developer
100% Remote
6 Months contract
No Client Interview
Details of the role
ETL Development role to implement enhancements to existing process.
Key responsibilities:
- Develop stable, secure, scalable, and highly performing Code /Components which are easy to inspect, test, service, and support.
- Delivery within time commitments adhering to approved designs, Deployment standards and meeting set quality goals confirming to coding standards & best practice with minimal defects.
- Drive customer communication for the project. Participate in regular client meetings that led to useful feedback and create project plans that deliver solutions to client problems.
- Learn to Influence team and stakeholders to proactively resolve issues
- Perform unit/module testing of software to find errors and confirm programs meet specifications.
- Write dev plan covering all scenarios based on information provided by customers and functional specs.
- Provide accurate time and resource estimates result in on-schedule delivery
- Mentor juniors in the team and take accountability for their delivery like reviewing deliverables, providing solutions and providing technical support and training.
- Contribute to solutioning and ensuring solutions adhere to established technological standards
- identify the scenarios/functionality that are missing or do not meet the customer needs or usability and take proper action
- Independently handle component level design
- Analyze and permit impact of change
- Independently handle component level design
- Recognize broader relationships between the solution and customer needs, iron out dependencies and deliver code that produces value
- Designs and implement proof of concept as needed for solutions as an individual contributor
- Expand software engineering knowledge beyond what is needed to complete the work. Learn new technologies/platforms during the spare time and present the learnings to others in the company
- Expertise and execute in Agile & other Delivery methodologies followed in the organization
Required Skills:
- Expertise in writing complex SQL queries
- Hands on experience on writing complex SQL queries using joins, aggregate/analytical functions, CTE etc.,
- Hands on experience in fine tuning the long running SQL Queries
- Expertise in developing Database components including creating views, stored procedures, triggers etc.
- Experience on RDBMS systems and concepts
- Extensive Experience in Data validation and Data Profiling
- Decent knowledge of transaction management mechanisms, ACID properties, Exception Handling
- Decent knowledge on data cardinality, Constraints, data quality rules, system level checks like, integrity check, isolation levels, compatibility levels in the system.
- Knowledge and hands-on experience with ETL development
- Hands on experience on implementing different loading strategies like SCD1 and SCD2, Table/ partition refresh, insert update, Swap Patriation etc.
- Experience in Consuming and writing data from and to Flat files, RDMBS systems, MPPS, Jason and XML.
- Ability to automate and build reusable executables for better delivery efficiency
- Ability to provide feasible and scalable Design/architecture for business requirements.
- Hands on experience on implementing efficient SSIS packages
- Experience in handling Operating system, ETL and Job scheduling and orchestration using SSIS
- Create test cases and perform unit testing of ETL Jobs
- Analytical mind with a problem-solving and debugging skills.
- Excellent Communication Skills
- Awareness of Replication, Synchronization and Disaster Management techniques
- Awareness of Data Quality Management
- Hands on experience on creating table partitions, indexes, views, materialized views etc.,
- Hands on experience in implementing data driven ETL designs
- Hands on experience in implementing reusable ETL components as per well-defined standards
- Efficient use of parameter and configuration files in ETL job implementation
- Hands on experience in applying performance tuning techniques on long running ETL Jobs
- Good to have knowledge of Agile Methodology (Scrum framework), JIRA
Regards,
----------------------------------------------------------
Surya Prakash
Technical Recruiter
Dynamiqal, LLC
260 Peachtree St NW Suite 2200, Atlanta, GA 30303
Phone: 619-359-0013 | Email : suryaitrecruit@gmail.com
You received this message because you are subscribed to the Google Groups "Hiringzone98" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hiringzone98+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/hiringzone98/f89f368c-8d8c-4af1-9afc-69ef1ac1bdd6n%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.